gallery

1 files changed, 24 insertions, 0 deletions

diff --git a/sql/functions/general.get_gallery.sql b/sql/functions/general.get_gallery.sql
new file mode 100644
index 0000000..66c9fce
--- /dev/null
+++ b/sql/functions/general.get_gallery.sql
@@ -0,0 +1,24 @@
+drop function general.get_gallery (
+    p_id bigint
+);
+
+create or replace function general.get_gallery (
+    p_id bigint
+)
+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
+    where g.id = p_id;
+
+    return;
+end;
+$$ language plpgsql;