-- -- etp__get_attribute_value/2 -- create or replace function etp__get_attribute_value( integer, integer ) returns varchar as $$ declare p_object_id alias for $1; p_attribute_id alias for $2; v_value varchar; begin select attr_value into v_value from acs_attribute_values where object_id = p_object_id and attribute_id = p_attribute_id; if not found then v_value := ''; end if; return v_value; end; $$ language plpgsql;