-- -- content_item__get_live_revision/1 -- create or replace function content_item__get_live_revision( integer ) returns int4 as $$ declare get_live_revision__item_id alias for $1; v_revision_id acs_objects.object_id%TYPE; begin select live_revision into v_revision_id from cr_items where item_id = get_live_revision__item_id; return v_revision_id; end;$$ language plpgsql;