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