From 2893bd1857d685cf892beac3a7429d03cf1a09f1 Mon Sep 17 00:00:00 2001
From: Andi Albrecht <albrecht.andi@gmail.com>
Date: Sat, 13 Aug 2016 17:38:21 +0200
Subject: Parse double dollars (PostgreSQL) as literal strings (fixes #277).

---
 tests/files/function_psql4.sql | 12 ++++++++++++
 1 file changed, 12 insertions(+)
 create mode 100644 tests/files/function_psql4.sql

(limited to 'tests/files/function_psql4.sql')

diff --git a/tests/files/function_psql4.sql b/tests/files/function_psql4.sql
new file mode 100644
index 0000000..02900a6
--- /dev/null
+++ b/tests/files/function_psql4.sql
@@ -0,0 +1,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
+$_$;
-- 
cgit v1.2.1

