Index: openacs-4/packages/dotlrn/www/admin/users-postgresql.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/dotlrn/www/admin/Attic/users-postgresql.xql,v
diff -u -r1.1 -r1.2
--- openacs-4/packages/dotlrn/www/admin/users-postgresql.xql	9 Jul 2002 12:39:33 -0000	1.1
+++ openacs-4/packages/dotlrn/www/admin/users-postgresql.xql	11 Jul 2002 15:54:13 -0000	1.2
@@ -1,19 +1,19 @@
 <?xml version="1.0"?>
 
 <queryset>
-    <rdbms><type>postgres</type><version>7.1</version></rdbms>
+    <rdbms><type>postgresql</type><version>7.1</version></rdbms>
 
     <fullquery name="select_non_dotlrn_users_count">
         <querytext>
             select count(*)
             from (select acs_rels.object_id_two
                   from acs_rels
                   where acs_rels.object_id_one = (select acs__magic_object_id('registered_users') from dual)
-                 minus
-                  select acs_rels.object_id_two
-                  from acs_rels,
-                  dotlrn_user_types
-                  where acs_rels.object_id_one = dotlrn_user_types.group_id)
+                  and acs_rels.object_id_two not in (                  
+                      select acs_rels.object_id_two
+                             from acs_rels,
+                             dotlrn_user_types
+                       where acs_rels.object_id_one = dotlrn_user_types.group_id)) as foo
         </querytext>
     </fullquery>