Index: openacs-4/packages/forums/www/message-view-postgresql.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/forums/www/message-view-postgresql.xql,v
diff -u -r1.6 -r1.7
--- openacs-4/packages/forums/www/message-view-postgresql.xql	18 Nov 2002 18:01:08 -0000	1.6
+++ openacs-4/packages/forums/www/message-view-postgresql.xql	28 Oct 2003 09:54:55 -0000	1.7
@@ -3,6 +3,18 @@
 <queryset>
     <rdbms><type>postgresql</type><version>7.1</version></rdbms>
 
+    <fullquery name="select_message_ordering">
+        <querytext>
+            select fma.message_id
+            from   forums_messages fm,
+                   forums_messages_approved fma
+            where  fm.message_id = :root_message_id
+            and    fma.forum_id = :forum_id
+            and    fma.tree_sortkey between fm.tree_sortkey and tree_right(fm.tree_sortkey)
+            order  by $order_by
+        </querytext>
+    </fullquery>
+
     <fullquery name="select_message_responses">
         <querytext>
             select message_id,
@@ -14,11 +26,12 @@
                    to_char(posting_date, 'YYYY-MM-DD HH24:MI:SS') as posting_date_ansi,
                    tree_level(tree_sortkey) as tree_level,
                    state,
-                   user_id
-            from $table_name
-            where forum_id = :forum_id
-            and tree_sortkey between tree_left(:tree_sortkey) and tree_right(:tree_sortkey)
-            order by $order_by
+                   user_id,
+                   parent_id
+            from   $table_name
+            where  forum_id = :forum_id
+            and    tree_sortkey between tree_left(:tree_sortkey) and tree_right(:tree_sortkey)
+            order  by $order_by
         </querytext>
     </fullquery>
 
@@ -33,11 +46,12 @@
                    to_char(posting_date, 'YYYY-MM-DD HH24:MI:SS') as posting_date_ansi,
                    tree_level(tree_sortkey) as tree_level,
                    state,
-                   user_id
-            from $table_name
-            where forum_id = :forum_id
-            and tree_sortkey between tree_left(:tree_sortkey) and tree_right(:tree_sortkey)
-            order by $order_by
+                   user_id,
+                   parent_id
+            from   $table_name
+            where  forum_id = :forum_id
+            and    tree_sortkey between tree_left(:tree_sortkey) and tree_right(:tree_sortkey)
+            order  by $order_by
         </querytext>
     </fullquery>