Index: openacs-4/packages/evaluation/sql/postgresql/evaluation-calendar-drop.sql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/evaluation/sql/postgresql/evaluation-calendar-drop.sql,v diff -u -r1.1 -r1.2 --- openacs-4/packages/evaluation/sql/postgresql/evaluation-calendar-drop.sql 10 Sep 2004 19:16:28 -0000 1.1 +++ openacs-4/packages/evaluation/sql/postgresql/evaluation-calendar-drop.sql 27 Oct 2014 16:41:24 -0000 1.2 @@ -1,12 +1,18 @@ -- deleting calendar mappings -create function inline_0 () -returns integer as ' -declare + + +-- +-- procedure inline_0/0 +-- +CREATE OR REPLACE FUNCTION inline_0( + +) RETURNS integer AS $$ +DECLARE v_cal_item_cursor RECORD; -begin +BEGIN FOR v_cal_item_cursor IN select map.cal_item_id @@ -19,10 +25,11 @@ END LOOP; return 0; -end; -' language 'plpgsql'; +END; +$$ LANGUAGE plpgsql; + select inline_0 (); drop function inline_0 ();