--
-- category__name/1
--
create or replace function category__name(
  integer
) returns int4 as $$

declare
    p_category_id       alias for $1;
    v_name      varchar;
begin
	select name into v_name
	from category_translations
	where category_id = p_category_id
	and locale = 'en_US';

        return 0;
end;
$$ language plpgsql;