-- -- acs_sc_contract__get_name/1 -- create or replace function acs_sc_contract__get_name( integer ) returns varchar as $$ declare p_contract_id alias for $1; v_contract_name varchar; begin select contract_name into v_contract_name from acs_sc_contracts where contract_id = p_contract_id; return v_contract_name; end;$$ language plpgsql;