-- -- category__edit/7 -- create or replace function category__edit( integer, character varying, character varying, character varying, timestamp with time zone, integer, character varying ) returns int4 as $$ declare p_category_id alias for $1; p_locale alias for $2; p_name alias for $3; p_description alias for $4; p_modifying_date alias for $5; p_modifying_user alias for $6; p_modifying_ip alias for $7; begin -- change category name update category_translations set name = p_name, description = p_description where category_id = p_category_id and locale = p_locale; update acs_objects set last_modified = p_modifying_date, modifying_user = p_modifying_user, modifying_ip = p_modifying_ip where object_id = p_category_id; return 0; end; $$ language plpgsql;