Index: openacs-4/packages/acs-subsite/www/admin/groups/rel-type-add-2-oracle.xql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/acs-subsite/www/admin/groups/rel-type-add-2-oracle.xql,v diff -u -N --- openacs-4/packages/acs-subsite/www/admin/groups/rel-type-add-2-oracle.xql 15 May 2001 16:59:00 -0000 1.1 +++ /dev/null 1 Jan 1970 00:00:00 -0000 @@ -1,47 +0,0 @@ - - - - oracle8.1.6 - - - - - select count(*) - from acs_rel_types t - where (t.object_type_one = :group_type - or acs_object_type.is_subtype_p(t.object_type_one, :group_type) = 't') - and t.rel_type = :rel_type - - - - - - - - - select case when exists (select 1 - from group_rels - where group_id = :group_id - and rel_type = :rel_type) - then 1 else 0 end - from dual - - - - - - - - - select case when exists (select 1 - from rel_segments s - where s.group_id = :group_id - and s.rel_type = :rel_type) - then 1 else 0 end - from dual - - - - - -