Index: openacs-4/packages/acs-kernel/sql/postgresql/acs-relationships-create.sql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/acs-kernel/sql/postgresql/acs-relationships-create.sql,v diff -u -r1.1 -r1.2 --- openacs-4/packages/acs-kernel/sql/postgresql/acs-relationships-create.sql 14 Mar 2001 04:39:10 -0000 1.1 +++ openacs-4/packages/acs-kernel/sql/postgresql/acs-relationships-create.sql 14 Mar 2001 14:07:31 -0000 1.2 @@ -440,14 +440,14 @@ from acs_object_types t where t.object_type = o1.object_type and t.tree_sortkey - like (select o.tree_sortkey || '%' + like (select o.tree_sortkey || ''%'' from acs_object_types o where o.object_type = rt.object_type_one)) and exists (select 1 from acs_object_types t where t.object_type = o2.object_type and t.tree_sortkey - like (select o.tree_sortkey || '%' + like (select o.tree_sortkey || ''%'' from acs_object_types o where o.object_type = rt.object_type_two)) and rt.rel_type = new.rel_type