summaryrefslogtreecommitdiff
path: root/sql/functions/general.get_galleries.sql
diff options
context:
space:
mode:
Diffstat (limited to 'sql/functions/general.get_galleries.sql')
-rw-r--r--sql/functions/general.get_galleries.sql6
1 files changed, 5 insertions, 1 deletions
diff --git a/sql/functions/general.get_galleries.sql b/sql/functions/general.get_galleries.sql
index fc93095..db3ad09 100644
--- a/sql/functions/general.get_galleries.sql
+++ b/sql/functions/general.get_galleries.sql
@@ -9,7 +9,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