summaryrefslogtreecommitdiff
path: root/tests/files/function_psql4.sql
blob: 02900a6f262d46945f5a0765823e31e330e6019d (plain)
1
2
3
4
5
6
7
8
9
10
11
12
CREATE FUNCTION doubledollarinbody(var1 text) RETURNS text
/* see issue277 */
LANGUAGE plpgsql
AS $_$
DECLARE
  str text;
  BEGIN
    str = $$'foo'$$||var1;
    execute 'select '||str into str;
    return str;
  END
$_$;