diff options
| author | ckonstanski <carlos.konstanski@olo.com> | 2024-05-27 16:57:01 -0600 |
|---|---|---|
| committer | ckonstanski <carlos.konstanski@olo.com> | 2024-05-27 16:57:01 -0600 |
| commit | ebd383b0e0a6168f99857126897b07395e24b41c (patch) | |
| tree | b3b37d7dda1d7562ece14e9c2396aa9cf6f72f30 /sql/functions/general.get_gallery.sql | |
| parent | 6f397b2cd6b825a105a06591aa30469aab767591 (diff) | |
embed youtobe videos
Diffstat (limited to 'sql/functions/general.get_gallery.sql')
| -rw-r--r-- | sql/functions/general.get_gallery.sql | 6 |
1 files changed, 5 insertions, 1 deletions
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 |