From e30ee019294e2abbbd3644b73e4327ae17df4392 Mon Sep 17 00:00:00 2001
From: ckonstanski <carlos.konstanski@olo.com>
Date: Mon, 27 May 2024 14:52:07 -0600
Subject: gallery

---
 sql/functions/general.get_galleries.sql | 20 ++++++++++++++++++++
 1 file changed, 20 insertions(+)
 create mode 100644 sql/functions/general.get_galleries.sql

(limited to 'sql/functions/general.get_galleries.sql')

diff --git a/sql/functions/general.get_galleries.sql b/sql/functions/general.get_galleries.sql
new file mode 100644
index 0000000..fc93095
--- /dev/null
+++ b/sql/functions/general.get_galleries.sql
@@ -0,0 +1,20 @@
+drop function general.get_galleries ();
+
+create or replace function general.get_galleries ()
+returns setof general.gallery_t
+as $$
+begin
+    return query
+    select g.id,
+        g.description,
+        g.filename,
+        g.mime_type,
+        substring(g.content::text from 3) as content,
+        g.created,
+        g.modified
+    from general.gallery g
+    order by g.modified desc;
+
+    return;
+end;
+$$ language plpgsql;
-- 
cgit v1.3