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