-- -- content_item__get_revision_count/1 -- create or replace function content_item__get_revision_count( integer ) returns int4 as $$ declare get_revision_count__item_id alias for $1; v_count integer; begin select count(*) into v_count from cr_revisions where item_id = get_revision_count__item_id; return v_count; end;$$ language plpgsql;