Index: openacs-4/packages/forums/tcl/forums-sc-procs-postgresql.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/forums/tcl/forums-sc-procs-postgresql.xql,v
diff -u -r1.1 -r1.2
--- openacs-4/packages/forums/tcl/forums-sc-procs-postgresql.xql 1 Sep 2003 22:22:14 -0000 1.1
+++ openacs-4/packages/forums/tcl/forums-sc-procs-postgresql.xql 1 Apr 2004 20:03:53 -0000 1.2
@@ -15,14 +15,24 @@
- select site_node__url(node_id)
+ select site_node__url(min(node_id))
from site_nodes
where object_id = (select package_id
from forums_forums
where forums_forums.forum_id = :forum_id)
+
+
+ select site_node__url(min(node_id))
+ from site_nodes
+ where object_id = (select package_id
+ from forums_forums
+ where forums_forums.forum_id = :forum_id)
+
+
+
select subject, content, html_p