summaryrefslogtreecommitdiff
path: root/templates/snippets/sql-mode
diff options
context:
space:
mode:
Diffstat (limited to 'templates/snippets/sql-mode')
-rw-r--r--templates/snippets/sql-mode/primitive-return-function13
-rw-r--r--templates/snippets/sql-mode/record-return-fuction18
2 files changed, 0 insertions, 31 deletions
diff --git a/templates/snippets/sql-mode/primitive-return-function b/templates/snippets/sql-mode/primitive-return-function
deleted file mode 100644
index bb7e79e..0000000
--- a/templates/snippets/sql-mode/primitive-return-function
+++ /dev/null
@@ -1,13 +0,0 @@
-# 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
deleted file mode 100644
index a3894c4..0000000
--- a/templates/snippets/sql-mode/record-return-fuction
+++ /dev/null
@@ -1,18 +0,0 @@
-# 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;