--
-- 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;