From ebd383b0e0a6168f99857126897b07395e24b41c Mon Sep 17 00:00:00 2001
From: ckonstanski <carlos.konstanski@olo.com>
Date: Mon, 27 May 2024 16:57:01 -0600
Subject: embed youtobe videos

---
 sql/functions/general.get_gallery.sql | 6 +++++-
 1 file changed, 5 insertions(+), 1 deletion(-)

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

diff --git a/sql/functions/general.get_gallery.sql b/sql/functions/general.get_gallery.sql
index 66c9fce..c0972f4 100644
--- a/sql/functions/general.get_gallery.sql
+++ b/sql/functions/general.get_gallery.sql
@@ -13,7 +13,11 @@ begin
         g.description,
         g.filename,
         g.mime_type,
-        substring(g.content::text from 3) as content,
+        g.video_embed_url,
+        case
+          when g.content is null then null
+          else substring(g.content::text from 3)
+        end as content,
         g.created,
         g.modified
     from general.gallery g
-- 
cgit v1.3