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.4 -r1.5
--- openacs-4/packages/acs-tcl/tcl/navigation-procs-postgresql.xql	6 Jul 2001 00:15:41 -0000	1.4
+++ openacs-4/packages/acs-tcl/tcl/navigation-procs-postgresql.xql	4 Dec 2001 00:20:47 -0000	1.5
@@ -9,8 +9,7 @@
            tree_level(n2.tree_sortkey) as level
     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 || '%')
+    where n1.tree_sortkey between n2.tree_sortkey and tree_right(n2.tree_sortkey)
  order by level asc
   
       </querytext>