-- -- pinds_blog_category__new/6 -- create or replace function pinds_blog_category__new( integer, integer, character varying, character varying, integer, character varying ) returns int4 as $$ declare p_category_id alias for $1; p_package_id alias for $2; p_name alias for $3; p_short_name alias for $4; p_creation_user alias for $5; p_creation_ip alias for $6; v_category_id integer; begin v_category_id := acs_object__new ( p_category_id, 'pinds_blog_category', current_timestamp, p_creation_user, p_creation_ip, p_package_id ); insert into pinds_blog_categories ( category_id, package_id, name, short_name ) values ( v_category_id, p_package_id, p_name, p_short_name ); return v_category_id; end; $$ language plpgsql;