-- -- content_revision__is_latest/1 -- create or replace function content_revision__is_latest( integer ) returns bool as $$ declare is_latest__revision_id alias for $1; begin return count(*) > 0 from cr_items where latest_revision = is_latest__revision_id; end;$$ language plpgsql;