Index: openacs-4/packages/acs-subsite/www/admin/relations/add-postgresql.xql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/acs-subsite/www/admin/relations/Attic/add-postgresql.xql,v diff -u -r1.4 -r1.4.2.1 --- openacs-4/packages/acs-subsite/www/admin/relations/add-postgresql.xql 8 Dec 2001 01:17:59 -0000 1.4 +++ openacs-4/packages/acs-subsite/www/admin/relations/add-postgresql.xql 13 Mar 2002 02:02:29 -0000 1.4.2.1 @@ -43,8 +43,8 @@ p.party_id from (select o.object_id as party_id from acs_objects o, - (select ot.object_type from acs_object_types ot, acs_object_types ot2 - where ot.tree_sortkey between ot2.tree_sortkey and tree_right(ot2.tree_sortkey) + (select ot2.object_type from acs_object_types ot, acs_object_types ot2 + where ot2.tree_sortkey between ot.tree_sortkey and tree_right(ot.tree_sortkey) and $start_with) t where o.object_type = t.object_type) p left join (select element_id