-- -- content_revision__revision_name/1 -- create or replace function content_revision__revision_name( integer ) returns text as $$ declare p_revision_id alias for $1; begin return 'Revision ' || content_revision__get_number(revision_id) || ' of ' || (select count(*) from cr_revisions where item_id = r.item_id) || ' for item: ' || content_item__get_title(item_id) from cr_revisions r where r.revision_id = p_revision_id; end;$$ language plpgsql;