Index: openacs-4/packages/acs-subsite/www/admin/groups/elements-display-list-postgresql.xql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/acs-subsite/www/admin/groups/elements-display-list-postgresql.xql,v diff -u -r1.4 -r1.5 --- openacs-4/packages/acs-subsite/www/admin/groups/elements-display-list-postgresql.xql 3 Sep 2001 20:51:38 -0000 1.4 +++ openacs-4/packages/acs-subsite/www/admin/groups/elements-display-list-postgresql.xql 7 Sep 2001 20:57:20 -0000 1.5 @@ -10,9 +10,10 @@ from acs_object_types where supertype = 'relationship' and object_type in ( - select t1.object_type + select t2.object_type from acs_object_types t1, acs_object_types t2 - where t2.tree_sortkey like (t1.tree_sortkey || '%') + where t2.tree_sortkey <= t1.tree_sortkey + and t1.tree_sortkey like (t2.tree_sortkey || '%') and t1.object_type = :rel_type )