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 -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 @@
postgresql7.1
-
--- FIX ME PLSQL
-
--- begin
- select acs_message__message_p(:message_id);
--- end;
-
-
+
+ select acs_message__message_p(:message_id);
+
-
-
-
-
- select acs_message__first_ancestor(:message_id) as ancestor_id
-
-
+
+
+ select acs_message__first_ancestor(:message_id) as ancestor_id
+
--- 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