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