Index: openacs-4/packages/acs-subsite/www/admin/group-types/change-join-policy-2-postgresql.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/acs-subsite/www/admin/group-types/Attic/change-join-policy-2-postgresql.xql,v
diff -u -N
--- openacs-4/packages/acs-subsite/www/admin/group-types/change-join-policy-2-postgresql.xql 15 May 2001 16:59:00 -0000 1.1
+++ /dev/null 1 Jan 1970 00:00:00 -0000
@@ -1,20 +0,0 @@
-
-
-
- postgresql7.1
-
-
-
- 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
- where t.object_type = :group_type
- and t.object_type = gt.group_type(+)
-
-
-
-
-
-
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 -N -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 @@
- 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(+)
Index: openacs-4/packages/acs-subsite/www/admin/group-types/change-join-policy-postgresql.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/acs-subsite/www/admin/group-types/Attic/change-join-policy-postgresql.xql,v
diff -u -N
--- openacs-4/packages/acs-subsite/www/admin/group-types/change-join-policy-postgresql.xql 15 May 2001 16:59:00 -0000 1.1
+++ /dev/null 1 Jan 1970 00:00:00 -0000
@@ -1,20 +0,0 @@
-
-
-
- postgresql7.1
-
-
-
- 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
- where t.object_type = :group_type
- and t.object_type = gt.group_type(+)
-
-
-
-
-
-
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 -N -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 @@
- 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(+)