2 files changed, 31 insertions, 0 deletions
diff --git a/templates/snippets/sql-mode/primitive-return-function b/templates/snippets/sql-mode/primitive-return-function
new file mode 100644
index 0000000..bb7e79e
--- /dev/null
+++ b/templates/snippets/sql-mode/primitive-return-function
@@ -0,0 +1,13 @@
+# key: fnp
+# name: Create function with primitive return value.
+# --
+drop function if exists $1();
+create or replace function $1(
+       $0
+)
+returns $2 as $$
+declare
+begin
+
+end;
+$$ language plpgsql;
+\ No newline at end of file
diff --git a/templates/snippets/sql-mode/record-return-fuction b/templates/snippets/sql-mode/record-return-fuction
new file mode 100644
index 0000000..a3894c4
--- /dev/null
+++ b/templates/snippets/sql-mode/record-return-fuction
@@ -0,0 +1,18 @@
+# key: fn
+# name: create a function which returns a full record
+# --
+drop type if exists $1_ret cascade;
+create type $1_ret as (
+       $2
+);
+
+drop function if exists $1();
+create or replace function $1(
+       $3
+)
+returns setof $1_ret as $$
+declare
+begin
+        $0
+end;
+$$ language plpgsql;