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,
        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
    order by g.modified desc;

    return;
end;
$$ language plpgsql;