summaryrefslogtreecommitdiff
path: root/tests/files/function.sql
diff options
context:
space:
mode:
Diffstat (limited to 'tests/files/function.sql')
-rw-r--r--tests/files/function.sql13
1 files changed, 13 insertions, 0 deletions
diff --git a/tests/files/function.sql b/tests/files/function.sql
new file mode 100644
index 0000000..d19227f
--- /dev/null
+++ b/tests/files/function.sql
@@ -0,0 +1,13 @@
+CREATE OR REPLACE FUNCTION foo(
+ p_in1 VARCHAR
+ , p_in2 INTEGER
+) RETURNS INTEGER AS
+
+ DECLARE
+ v_foo INTEGER;
+ BEGIN
+ SELECT *
+ FROM foo
+ INTO v_foo;
+ RETURN v_foo.id;
+ END; \ No newline at end of file