-- -- content_item__get_context/1 -- create or replace function content_item__get_context( integer ) returns int4 as $$ declare get_context__item_id alias for $1; v_context_id acs_objects.context_id%TYPE; begin select context_id into v_context_id from acs_objects where object_id = get_context__item_id; if NOT FOUND then raise EXCEPTION '-20000: Content item % does not exist in content_item.get_context', get_context__item_id; end if; return v_context_id; end;$$ language plpgsql;