Index: openacs-4/packages/faq/sql/postgresql/faq-sc-create.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/faq/sql/postgresql/faq-sc-create.sql,v
diff -u -r1.2 -r1.3
--- openacs-4/packages/faq/sql/postgresql/faq-sc-create.sql	7 Oct 2007 22:37:00 -0000	1.2
+++ openacs-4/packages/faq/sql/postgresql/faq-sc-create.sql	27 Oct 2014 16:41:29 -0000	1.3
@@ -8,31 +8,29 @@
 --
 
 create function faq_sc__itrg ()
-returns opaque as '
-    begin
-    perform search_observer__enqueue(new.entry_id,''INSERT''); 
+returns opaque as $$
+begin
+    perform search_observer__enqueue(new.entry_id,'INSERT'); 
     return new;
-    end; ' 
-language 'plpgsql';
+end; 
+$$ language plpgsql;
 
 create function faq_sc__dtrg ()
-returns opaque as '
-    begin
-    perform search_observer__enqueue(old.entry_id,''DELETE''); 
+returns opaque as $$
+begin
+    perform search_observer__enqueue(old.entry_id,'DELETE'); 
     return old;
-    end; ' 
-language 'plpgsql';
+end;
+$$ language plpgsql;
 
 create function faq_sc__utrg ()
-returns opaque as '
-    begin
-    perform search_observer__enqueue(old.entry_id,''UPDATE''); 
+returns opaque as $$
+begin
+    perform search_observer__enqueue(old.entry_id,'UPDATE'); 
     return old;
-    end; ' 
-language 'plpgsql';
+end; 
+$$ language plpgsql;
 
 create trigger faq_sc__itrg after insert on faq_q_and_as for each row execute procedure faq_sc__itrg ();
-
 create trigger faq_sc__dtrg after delete on faq_q_and_as for each row execute procedure faq_sc__dtrg ();
-
 create trigger faq_sc__utrg after update on faq_q_and_as for each row execute procedure faq_sc__utrg ();