Index: openacs-4/packages/acs-subsite/www/register/awaiting-email-verification-postgresql.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/acs-subsite/www/register/Attic/awaiting-email-verification-postgresql.xql,v
diff -u -r1.3 -r1.4
--- openacs-4/packages/acs-subsite/www/register/awaiting-email-verification-postgresql.xql	10 Feb 2002 22:11:31 -0000	1.3
+++ openacs-4/packages/acs-subsite/www/register/awaiting-email-verification-postgresql.xql	14 Feb 2002 00:53:10 -0000	1.4
@@ -6,12 +6,13 @@
 <fullquery name="register_user_state_properties">      
       <querytext>
       
-    select mr.member_state, p.email, u.oid as rowid 
-    from users u
-    JOIN parties p on (p.party_id = u.user_id)
-    LEFT JOIN membership_rels mr on (mr.rel_id = u.user_id)
-    where u.user_id = :user_id 
-    and u.email_verified_p = 'f' 
+     select mr.member_state, p.email, u.oid as row_id
+     from users u
+     JOIN parties p on (p.party_id = u.user_id)
+     LEFT JOIN membership_rels mr on (mr.rel_id = u.user_id)
+     where u.user_id = :user_id
+     and u.email_verified_p = 'f'
+
       </querytext>
 </fullquery>