-- -- acs_sc_impl__get_name/1 -- create or replace function acs_sc_impl__get_name( integer ) returns varchar as $$ declare p_impl_id alias for $1; v_impl_name varchar; begin select impl_name into v_impl_name from acs_sc_impls where impl_id = p_impl_id; return v_impl_name; end;$$ language plpgsql;