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

declare
    p_category_id alias for $1;
begin
    update pinds_blog_entries
        set category_id = null
        where category_id = p_category_id;

    delete from pinds_blog_categories
        where category_id = p_category_id;

    PERFORM acs_object__delete(p_category_id);
    return 0;
end;
$$ language plpgsql;