Index: openacs-4/packages/dotlrn/www/communities-chunk-postgresql.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/dotlrn/www/communities-chunk-postgresql.xql,v
diff -u -r1.1 -r1.2
--- openacs-4/packages/dotlrn/www/communities-chunk-postgresql.xql	15 Jul 2002 20:12:46 -0000	1.1
+++ openacs-4/packages/dotlrn/www/communities-chunk-postgresql.xql	8 Aug 2002 13:34:30 -0000	1.2
@@ -25,7 +25,7 @@
                                                         'admin') = 'f'
                       THEN 0
                       ELSE 1
-                   END as admin_p
+                   END as admin_p,
                    (select dotlrn_community_types.community_type
                     from dotlrn_community_types
                     where dotlrn_community_types.tree_sortkey = tree_ancestor_key(dotlrn_communities.tree_sortkey, 1)) as root_community_type
@@ -54,7 +54,7 @@
                                                         'admin') = 'f'
                       THEN 0
                       ELSE 1
-                   END as admin_p
+                   END as admin_p,
                    (select dotlrn_community_types.community_type
                     from dotlrn_community_types
                     where dotlrn_community_types.tree_sortkey = tree_ancestor_key(dotlrn_communities.tree_sortkey, 1)) as root_community_type
@@ -83,7 +83,7 @@
                                                         'admin') = 'f'
                       THEN 0
                       ELSE 1
-                   END as admin_p
+                   END as admin_p,
                    (select dotlrn_community_types.community_type
                     from dotlrn_community_types
                     where dotlrn_community_types.tree_sortkey = tree_ancestor_key(dotlrn_communities.tree_sortkey, 1)) as root_community_type
@@ -113,7 +113,7 @@
                                                         'admin') = 'f'
                       THEN 0
                       ELSE 1
-                   END as admin_p
+                   END as admin_p,
                    (select dotlrn_community_types.community_type
                     from dotlrn_community_types
                     where dotlrn_community_types.tree_sortkey = tree_ancestor_key(dotlrn_communities.tree_sortkey, 1)) as root_community_type
@@ -152,7 +152,7 @@
                                                         'admin') = 'f'
                       THEN 0
                       ELSE 1
-                   END as admin_p
+                   END as admin_p,
                    (select dotlrn_community_types.community_type
                     from dotlrn_community_types
                     where dotlrn_community_types.tree_sortkey = tree_ancestor_key(dotlrn_communities.tree_sortkey, 1)) as root_community_type
@@ -182,7 +182,7 @@
                                                         'admin') = 'f'
                       THEN 0
                       ELSE 1
-                   END as admin_p
+                   END as admin_p,
                    (select dotlrn_community_types.community_type
                     from dotlrn_community_types
                     where dotlrn_community_types.tree_sortkey = tree_ancestor_key(dotlrn_communities.tree_sortkey, 1)) as root_community_type
@@ -212,7 +212,7 @@
                                                         'admin') = 'f'
                       THEN 0
                       ELSE 1
-                   END as admin_p
+                   END as admin_p,
                    (select dotlrn_community_types.community_type
                     from dotlrn_community_types
                     where dotlrn_community_types.tree_sortkey = tree_ancestor_key(dotlrn_communities.tree_sortkey, 1)) as root_community_type
@@ -243,7 +243,7 @@
                                                         'admin') = 'f'
                       THEN 0
                       ELSE 1
-                   END as admin_p
+                   END as admin_p,
                    (select dotlrn_community_types.community_type
                     from dotlrn_community_types
                     where dotlrn_community_types.tree_sortkey = tree_ancestor_key(dotlrn_communities.tree_sortkey, 1)) as root_community_type