--
-- category_tree__name/1
--
create or replace function category_tree__name(
  integer
) returns varchar as $$

declare
    p_tree_id                alias for $1;
    v_name                   varchar;
begin
	select name into v_name
	from category_tree_translations
	where tree_id = p_tree_id
	and locale = 'en_US';

	return v_name;
end;
$$ language plpgsql;