-
Notifications
You must be signed in to change notification settings - Fork 3.5k
/
dollar_strings.expect.txt
9 lines (8 loc) · 1.05 KB
/
dollar_strings.expect.txt
1
2
3
4
5
6
7
8
9
<span class="hljs-keyword">CREATE</span> <span class="hljs-keyword">OR REPLACE</span> <span class="hljs-keyword">FUNCTION</span> hello_world(param_your_name <span class="hljs-type">text</span>)
<span class="hljs-keyword">RETURNS</span> <span class="hljs-type">text</span> <span class="hljs-keyword">AS</span>
$$<span class="pgsql">
<span class="hljs-keyword">SELECT</span> <span class="hljs-string">'Hello world. My name is '</span> || param_your_name || <span class="hljs-string">'.'</span>;
$$</span>
<span class="hljs-keyword">language</span> <span class="hljs-keyword">sql</span> <span class="hljs-keyword">STRICT</span>;
<span class="hljs-keyword">SELECT</span> sql_expression($sql$<span class="tcl">SELECT hello_world(<span class="hljs-variable">$phrase</span><span class="hljs-variable">$Regina</span>'s elephant's dog<span class="hljs-variable">$phrase</span>$)
|| <span class="hljs-variable">$phrase</span>$ I made a cat's meow today.<span class="hljs-variable">$phrase</span>$ <span class="hljs-variable">$sql</span>$</span>);