From e9b16c36ee6f3c77d6b1c303826804f2e047d21c Mon Sep 17 00:00:00 2001
From: benj <benj@rse8.com>
Date: Sun, 18 Jul 2021 13:38:07 -0700
Subject: - yasnippet for quick plpgsql functions - fallback font for emoji
 support

---
 templates/snippets/sql-mode/primitive-return-function | 13 +++++++++++++
 templates/snippets/sql-mode/record-return-fuction     | 18 ++++++++++++++++++
 2 files changed, 31 insertions(+)
 create mode 100644 templates/snippets/sql-mode/primitive-return-function
 create mode 100644 templates/snippets/sql-mode/record-return-fuction

(limited to 'templates')

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;
-- 
cgit v1.2.3