Index: openacs-4/packages/acs-tcl/tcl/site-nodes-procs-postgresql.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/acs-tcl/tcl/site-nodes-procs-postgresql.xql,v
diff -u -r1.15 -r1.16
--- openacs-4/packages/acs-tcl/tcl/site-nodes-procs-postgresql.xql	14 Sep 2002 20:20:47 -0000	1.15
+++ openacs-4/packages/acs-tcl/tcl/site-nodes-procs-postgresql.xql	17 May 2003 10:04:18 -0000	1.16
@@ -14,6 +14,7 @@
             select site_node__url(site_nodes.node_id) as url,
                    site_nodes.node_id,
                    site_nodes.parent_id,
+                   site_nodes.name,
                    site_nodes.directory_p,
                    site_nodes.pattern_p,
                    site_nodes.object_id,
@@ -32,6 +33,7 @@
             select site_node__url(site_nodes.node_id) as url,
                    site_nodes.node_id,
                    site_nodes.parent_id,
+                   site_nodes.name,
                    site_nodes.directory_p,
                    site_nodes.pattern_p,
                    site_nodes.object_id,
@@ -51,6 +53,7 @@
             select site_node__url(node_id)
             from site_nodes
             where object_id = :object_id
+            order by site_node__url(node_id) desc
         </querytext>
     </fullquery>