--
-- 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;