diff options
Diffstat (limited to 'templates/snippets/sql-mode')
| -rw-r--r-- | templates/snippets/sql-mode/primitive-return-function | 13 | ||||
| -rw-r--r-- | templates/snippets/sql-mode/record-return-fuction | 18 |
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; |
