Fisheye: Tag 1.2 refers to a dead (removed) revision in file `openacs-4/packages/acs-subsite/www/admin/group-types/change-join-policy-2-postgresql.xql'.
Fisheye: No comparison available.  Pass `N' to diff?
Index: openacs-4/packages/acs-subsite/www/admin/group-types/change-join-policy-2.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/acs-subsite/www/admin/group-types/change-join-policy-2.xql,v
diff -u -r1.1 -r1.2
--- openacs-4/packages/acs-subsite/www/admin/group-types/change-join-policy-2.xql	15 May 2001 16:59:00 -0000	1.1
+++ openacs-4/packages/acs-subsite/www/admin/group-types/change-join-policy-2.xql	23 Aug 2001 22:02:23 -0000	1.2
@@ -3,13 +3,11 @@
 
 <fullquery name="select_pretty_name">      
       <querytext>
-      FIX ME OUTER JOIN
 
     select t.dynamic_p,
            case when gt.group_type = null then 0 else 1 end as group_type_exists_p
-      from acs_object_types t, group_types gt
+      from acs_object_types t left outer join group_types gt on (t.object_type = gt.group_type)
      where t.object_type = :group_type
-       and t.object_type = gt.group_type(+)
 
       </querytext>
 </fullquery>
Fisheye: Tag 1.2 refers to a dead (removed) revision in file `openacs-4/packages/acs-subsite/www/admin/group-types/change-join-policy-postgresql.xql'.
Fisheye: No comparison available.  Pass `N' to diff?
Index: openacs-4/packages/acs-subsite/www/admin/group-types/change-join-policy.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/acs-subsite/www/admin/group-types/change-join-policy.xql,v
diff -u -r1.1 -r1.2
--- openacs-4/packages/acs-subsite/www/admin/group-types/change-join-policy.xql	15 May 2001 16:59:00 -0000	1.1
+++ openacs-4/packages/acs-subsite/www/admin/group-types/change-join-policy.xql	23 Aug 2001 22:02:23 -0000	1.2
@@ -3,13 +3,11 @@
 
 <fullquery name="select_pretty_name">      
       <querytext>
-      FIX ME OUTER JOIN
 
     select t.pretty_name as group_type_pretty_name, t.dynamic_p,
            coalesce(gt.default_join_policy, 'open') as default_join_policy
-      from acs_object_types t, group_types gt
+      from acs_object_types t left outer join group_types gt on (t.object_type = gt.group_type)
      where t.object_type = :group_type
-       and t.object_type = gt.group_type(+)
 
       </querytext>
 </fullquery>