Index: openacs-4/packages/acs-tcl/tcl/navigation-procs-postgresql.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/acs-tcl/tcl/Attic/navigation-procs-postgresql.xql,v
diff -u -r1.2 -r1.3
--- openacs-4/packages/acs-tcl/tcl/navigation-procs-postgresql.xql	24 Apr 2001 06:02:27 -0000	1.2
+++ openacs-4/packages/acs-tcl/tcl/navigation-procs-postgresql.xql	24 Apr 2001 22:38:12 -0000	1.3
@@ -4,14 +4,12 @@
 <fullquery name="ad_context_bar.context">      
       <querytext>
       
-    select site_node__url(node_id) as url, object_id,
-           acs_object__name(object_id) as object_name,
+    select site_node__url(n2.node_id) as url, n2.object_id,
+           acs_object__name(n2.object_id) as object_name,
            tree_level(n2.tree_sortkey) as level
-    from site_nodes n1, site_nodes n2
-    where n1.tree_sortkey = (select tree_sortkey
-                              from site_nodes
-                             where node_id = :node_id)
-      and n2.tree_sortkey <= n1.tree_sortkey
+    from (select * from site_nodes where node_id = :node_id) n1,
+        site_nodes n2
+    where n2.tree_sortkey <= n1.tree_sortkey
       and n1.tree_sortkey like (n2.tree_sortkey || '%')
  order by level desc