--
-- content_revision__get_number/1
--
create or replace function content_revision__get_number(
  get_number__revision_id integer
) returns int4 as $$

DECLARE
  v_revision                         cr_revisions.revision_id%TYPE;
  v_row_count                        integer default 0;
  rev_cur                            record;
BEGIN
  for rev_cur in select
                   revision_id
                 from
                   cr_revisions r, acs_objects o
                 where
                   item_id = (select item_id from cr_revisions
                               where revision_id = get_number__revision_id)
                 and
                   o.object_id = r.revision_id
                 order by
                   o.creation_date,
                   r.revision_id
  LOOP
    v_row_count := v_row_count + 1;
    if rev_cur.revision_id = get_number__revision_id then
       return v_row_count;
       exit;
    end if;
  end LOOP;

  return null;

END;
$$ language plpgsql;