diff options
Diffstat (limited to 'tests/files/function.sql')
| -rw-r--r-- | tests/files/function.sql | 13 |
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 |
