-- -- fs_simple_object__new/9 -- create or replace function fs_simple_object__new( integer, character varying, integer, character varying, character varying, timestamp with time zone, integer, character varying, integer ) returns int4 as $$ DECLARE p_object_id alias for $1; p_object_type alias for $2; p_folder_id alias for $3; p_name alias for $4; p_description alias for $5; p_creation_date alias for $6; p_creation_user alias for $7; p_creation_ip alias for $8; p_context_id alias for $9; v_object_id integer; BEGIN v_object_id:= acs_object__new ( p_object_id, p_object_type, p_creation_date, p_creation_user, p_creation_ip, p_context_id ); insert into fs_simple_objects (object_id, folder_id, name, description) values (v_object_id, p_folder_id, p_name, p_description); acs_object__update_last_modified(p_folder_id); return v_object_id; END; $$ language plpgsql;