Index: openacs-4/packages/acs-messaging/tcl/acs-messaging-procs-postgresql.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/acs-messaging/tcl/acs-messaging-procs-postgresql.xql,v
diff -u -N -r1.2 -r1.3
--- openacs-4/packages/acs-messaging/tcl/acs-messaging-procs-postgresql.xql	13 May 2001 02:58:53 -0000	1.2
+++ openacs-4/packages/acs-messaging/tcl/acs-messaging-procs-postgresql.xql	30 May 2001 04:34:02 -0000	1.3
@@ -4,30 +4,20 @@
    <rdbms><type>postgresql</type><version>7.1</version></rdbms>
 
 <fullquery name="acs_message_p.acs_message_p">      
-      <querytext>
---      FIX ME PLSQL
-
---	begin
-	    select acs_message__message_p(:message_id);
---	end;
-    
-      </querytext>
+    <querytext>
+        select acs_message__message_p(:message_id);
+    </querytext>
 </fullquery>
-
  
-<fullquery name="acs_messaging_first_ancestor.acs_message_first_ancestor">      
-      <querytext>
-      
-	select acs_message__first_ancestor(:message_id) as ancestor_id 
-    
-      </querytext>
+<fullquery name="acs_messaging_first_ancestor.acs_message_first_ancestor">
+    <querytext>
+        select acs_message__first_ancestor(:message_id) as ancestor_id 
+    </querytext>
 </fullquery>
 
  
 <fullquery name="acs_messaging_process_queue.acs_message_send">      
       <querytext>
---      FIX ME OUTER JOIN
--- Hope this is right syntax
         select o.message_id as sending_message_id,
                o.to_address as recip_email,
                p.email as sender_email,
@@ -38,11 +28,9 @@
                m.content,
                m2.rfc822_id as in_reply_to
             from acs_messages_outgoing o,
-                 acs_messages_all m,
-                 acs_messages_all m2,
+                 acs_messages_all m left outer join acs_messages_all m2 on (m2.message_id = m.reply_to),
                  parties p
             where o.message_id = m.message_id
-                and left join m2 using (m2.message_id = m.reply_to)
                 and p.party_id = m.sender
                 and wait_until <= current_timestamp