summaryrefslogtreecommitdiff
path: root/tests/files/function_psql3.sql
diff options
context:
space:
mode:
Diffstat (limited to 'tests/files/function_psql3.sql')
-rw-r--r--tests/files/function_psql3.sql8
1 files changed, 8 insertions, 0 deletions
diff --git a/tests/files/function_psql3.sql b/tests/files/function_psql3.sql
new file mode 100644
index 0000000..b25d818
--- /dev/null
+++ b/tests/files/function_psql3.sql
@@ -0,0 +1,8 @@
+CREATE OR REPLACE FUNCTION foo() RETURNS integer AS
+$body$
+DECLARE
+BEGIN
+ select * from foo;
+END;
+$body$
+LANGUAGE 'plpgsql' VOLATILE CALLED ON NULL INPUT SECURITY INVOKER; \ No newline at end of file