Index: openacs-4/packages/bulk-mail/sql/postgresql/bulk-mail-drop.sql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/bulk-mail/sql/postgresql/bulk-mail-drop.sql,v diff -u -r1.2.22.1 -r1.2.22.2 --- openacs-4/packages/bulk-mail/sql/postgresql/bulk-mail-drop.sql 18 Aug 2014 20:54:39 -0000 1.2.22.1 +++ openacs-4/packages/bulk-mail/sql/postgresql/bulk-mail-drop.sql 5 Sep 2014 16:27:13 -0000 1.2.22.2 @@ -5,11 +5,11 @@ -- @version $Id$ -- -create function inline_0 () -returns integer as' -declare +CREATE FUNCTION inline_0 () +RETURNS integer AS $$ +DECLARE row RECORD; -begin +BEGIN for row in select bulk_mail_id from bulk_mail_messages loop perform bulk_mail__delete(row.bulk_mail_id);