Index: openacs-4/contrib/packages/classified-ads/tcl/categories-procs-postgresql.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/contrib/packages/classified-ads/tcl/categories-procs-postgresql.xql,v
diff -u -N -r1.4 -r1.4.2.1
--- openacs-4/contrib/packages/classified-ads/tcl/categories-procs-postgresql.xql	31 Jul 2003 09:31:00 -0000	1.4
+++ openacs-4/contrib/packages/classified-ads/tcl/categories-procs-postgresql.xql	1 Feb 2004 02:14:30 -0000	1.4.2.1
@@ -110,7 +110,10 @@
                 		   subtree.keyword_id
 		              from cr_keywords parent, cr_keywords subtree
 		             where parent.keyword_id = :keyword_id 
-			       and subtree.tree_sortkey between parent.tree_sortkey and tree_right(parent.tree_sortkey)
+			       and parent.tree_sortkey between 
+			               subtree.tree_sortkey 
+				   and 
+				       tree_right(subtree.tree_sortkey)
 		   ) keywords
 	    WHERE
 	          att.attribute_id = ca.attribute_id
@@ -133,7 +136,10 @@
                 		   subtree.keyword_id
 		              from cr_keywords parent, cr_keywords subtree
 		             where parent.keyword_id = :keyword_id 
-			       and subtree.tree_sortkey between parent.tree_sortkey and tree_right(parent.tree_sortkey)
+			       and parent.tree_sortkey between 
+			               subtree.tree_sortkey 
+				   and 
+				       tree_right(subtree.tree_sortkey)
 		   ) keywords
 	    WHERE
 	          att.attribute_id = ca.attribute_id