Index: openacs-4/packages/assessment/sql/postgresql/assessment-drop.sql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/assessment/sql/postgresql/assessment-drop.sql,v diff -u -N -r1.6 -r1.7 --- openacs-4/packages/assessment/sql/postgresql/assessment-drop.sql 30 Jan 2005 14:16:14 -0000 1.6 +++ openacs-4/packages/assessment/sql/postgresql/assessment-drop.sql 27 Oct 2014 16:40:56 -0000 1.7 @@ -11,20 +11,27 @@ drop function as_inter_item_check__delete (integer); -create function inline_0() -returns integer as ' -declare + + +-- +-- procedure inline_0/0 +-- +CREATE OR REPLACE FUNCTION inline_0( + +) RETURNS integer AS $$ +DECLARE object_rec record; -begin +BEGIN -- drop objects - for object_rec in select object_id from acs_objects where object_type = ''as_inter_item_check'' + for object_rec in select object_id from acs_objects where object_type = 'as_inter_item_check' loop PERFORM acs_object__delete ( object_rec.object_id ); end loop; return 0; -end;' language 'plpgsql'; +END; +$$ LANGUAGE plpgsql; select inline_0();