Index: openacs.org-dev/packages/forums/tcl/messages-procs-postgresql.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs.org-dev/packages/forums/tcl/messages-procs-postgresql.xql,v
diff -u -r1.4 -r1.5
--- openacs.org-dev/packages/forums/tcl/messages-procs-postgresql.xql	14 Aug 2002 01:45:38 -0000	1.4
+++ openacs.org-dev/packages/forums/tcl/messages-procs-postgresql.xql	5 Sep 2002 17:27:47 -0000	1.5
@@ -10,7 +10,7 @@
                    party__email(forums_messages.user_id) as user_email,
                    forums_forum__name(forums_messages.forum_id) as forum_name, 
                    forums_message__root_message_id(forums_messages.message_id) as root_message_id,
-                   (                 
+                   (
                     select forums_message__get_subject(forums_message__root_message_id(forums_messages.message_id))) as root_subject, 
                    to_char(forums_messages.posting_date, 'Mon DD YYYY HH24:MI:SS') as posting_date
             from forums_messages
@@ -26,7 +26,8 @@
                    party__email(forums_messages.user_id) as user_email,
                    forums_forum__name(forums_messages.forum_id) as forum_name, 
                    forums_message__root_message_id(forums_messages.message_id) as root_message_id,
-                   (select forums_message__get_subject(forums_message__root_message_id(forums_messages.message_id))) as root_subject, 
+                   (
+                    select forums_message__get_subject(forums_message__root_message_id(forums_messages.message_id))) as root_subject, 
                    to_char(forums_messages.posting_date, 'Mon DD YYYY HH24:MI:SS') as posting_date
             from forums_messages
             where forums_messages.message_id= :message_id
@@ -45,23 +46,19 @@
 
     <fullquery name="forum::message::delete.delete_message">
         <querytext>
-               select forums_message__delete_thread(:message_id)
+            select forums_message__delete_thread(:message_id);
         </querytext>
     </fullquery>
 
     <fullquery name="forum::message::close.thread_close">
         <querytext>
-            declare begin
-                forums_message__thread_close(:message_id);
-            end;
+            select forums_message__thread_close(:message_id);
         </querytext>
     </fullquery>
 
     <fullquery name="forum::message::open.thread_open">
         <querytext>
-            declare begin
-                forums_message__thread_open(:message_id);
-            end;
+            select forums_message__thread_open(:message_id);
         </querytext>
     </fullquery>