-- -- file_storage__get_title/1 -- create or replace function file_storage__get_title( integer ) returns varchar as $$ declare get_title__item_id alias for $1; v_title cr_revisions.title%TYPE; v_content_type cr_items.content_type%TYPE; begin select content_type into v_content_type from cr_items where item_id = get_title__item_id; if v_content_type = 'content_folder' then select label into v_title from cr_folders where folder_id = get_title__item_id; else if v_content_type = 'content_symlink' then select label into v_title from cr_symlinks where symlink_id = get_title__item_id; else select title into v_title from cr_revisions, cr_items where revision_id=live_revision and cr_items.item_id=get_title__item_id; end if; end if; return v_title; end;$$ language plpgsql;