Index: openacs-4/packages/survey/sql/postgresql/survey-notifications-drop.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/survey/sql/postgresql/survey-notifications-drop.sql,v
diff -u -N -r1.1 -r1.2
--- openacs-4/packages/survey/sql/postgresql/survey-notifications-drop.sql	20 Sep 2008 11:45:01 -0000	1.1
+++ openacs-4/packages/survey/sql/postgresql/survey-notifications-drop.sql	6 Nov 2013 07:33:54 -0000	1.2
@@ -4,44 +4,50 @@
 -- @creation-date 2002-08-03
 --
 -- integration with Notifications
-create function inline_0 ()
-returns integer as '
 
-declare
+
+--
+-- procedure inline_0/0
+--
+CREATE OR REPLACE FUNCTION inline_0(
+
+) RETURNS integer AS $$
+DECLARE
         impl_id integer;
         v_foo   integer;
-begin
+BEGIN
 
 
       v_foo := acs_sc_impl_alias__delete (
-		    ''NotificationType'',
-                    ''survey_response_notif_type'',
-                    ''GetURL''
+		    'NotificationType',
+                    'survey_response_notif_type',
+                    'GetURL'
                  );
 
       v_foo := acs_sc_impl_alias__delete (
-                    ''NotificationType'',
-                    ''survey_response_notif_type'',
-                    ''ProcessReply''
+                    'NotificationType',
+                    'survey_response_notif_type',
+                    'ProcessReply'
                  );
 
       v_foo := acs_sc_binding__delete (
-                    ''NotificationType'',
-                    ''survey_response_notif_type''
+                    'NotificationType',
+                    'survey_response_notif_type'
                  );
 
-       SELECT type_id from notification_types where short_name = ''survey_response_notif''
+       SELECT type_id from notification_types where short_name = 'survey_response_notif'
        INTO v_foo;
 
        v_foo := notification_type__delete(v_foo);
 
        v_foo := acs_sc_impl__delete (
-                     ''NotificationType'',
-                     ''survey_response_notif_type''
+                     'NotificationType',
+                     'survey_response_notif_type'
                   );
 
 return 0;
-end;' language 'plpgsql';
+END;
+$$ LANGUAGE plpgsql;
 
 select inline_0();