-- -- rel_constraint__get_constraint_id/3 -- create or replace function rel_constraint__get_constraint_id( integer, character, integer ) returns int4 as $$ declare get_constraint_id__rel_segment alias for $1; get_constraint_id__rel_side alias for $2; get_constraint_id__required_rel_segment alias for $3; v_constraint_id rel_constraints.constraint_id%TYPE; begin return constraint_id from rel_constraints where rel_segment = get_constraint_id__rel_segment and rel_side = get_constraint_id__rel_side and required_rel_segment = get_constraint_id__required_rel_segment; end;$$ language plpgsql;