Index: openacs-4/packages/calendar/sql/postgresql/calendar-notifications-init.sql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/calendar/sql/postgresql/calendar-notifications-init.sql,v diff -u -r1.2 -r1.3 --- openacs-4/packages/calendar/sql/postgresql/calendar-notifications-init.sql 12 Aug 2013 09:34:30 -0000 1.2 +++ openacs-4/packages/calendar/sql/postgresql/calendar-notifications-init.sql 4 Sep 2017 08:10:38 -0000 1.3 @@ -5,13 +5,12 @@ -- -- procedure inline_0/0 -- -CREATE OR REPLACE FUNCTION inline_0( - -) RETURNS integer AS $$ -DECLARE +create or replace function inline_0( +) returns integer AS $$ +declare impl_id integer; v_notification_id integer; -BEGIN +begin -- the notification type impl impl_id := acs_sc_impl__new ( 'NotificationType', @@ -64,9 +63,9 @@ from notification_delivery_methods where short_name in ('email'); return (0); -END; +end; $$ LANGUAGE plpgsql; select inline_0(); -drop function inline_0(); \ No newline at end of file +drop function inline_0();