-- -- content_item__get_latest_revision/1 -- create or replace function content_item__get_latest_revision( integer ) returns int4 as $$ declare get_latest_revision__item_id alias for $1; v_revision_id integer; v_rec record; begin for v_rec in select r.revision_id from cr_revisions r, acs_objects o where r.revision_id = o.object_id and r.item_id = get_latest_revision__item_id order by o.creation_date desc LOOP v_revision_id := v_rec.revision_id; exit; end LOOP; return v_revision_id; end;$$ language plpgsql;