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

declare
    p_category_id     alias for $1;
    v_name            varchar;
begin
    select name into v_name
        from pinds_blog_categories
        where category_id = p_category_id;
    return v_name;
end;
$$ language plpgsql;