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