Index: openacs-4/packages/dotlrn/www/admin/users-search-postgresql.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/dotlrn/www/admin/Attic/users-search-postgresql.xql,v
diff -u -r1.1.2.1 -r1.1.2.2
--- openacs-4/packages/dotlrn/www/admin/users-search-postgresql.xql	13 Sep 2005 04:34:37 -0000	1.1.2.1
+++ openacs-4/packages/dotlrn/www/admin/users-search-postgresql.xql	12 Nov 2005 23:54:29 -0000	1.1.2.2
@@ -15,13 +15,13 @@
   
   <partialquery name="last_visit_g">
     <querytext>
-    (dotlrn_users.user_id = users.user_id and users.last_visit <= (now() - to_interval(:last_visit_greater,'days')))
+    (dotlrn_users.user_id = users.user_id and users.last_visit <= (current_timestamp - (:last_visit_greater || 'days') :: interval ))
     </querytext>
   </partialquery>
   
   <partialquery name="last_visit_l">
     <querytext>
-    (dotlrn_users.user_id = users.user_id and users.last_visit >= (now() - to_interval(:last_visit_less,'days')))
+    (dotlrn_users.user_id = users.user_id and users.last_visit >= (current_timestamp - (:last_visit_less || 'days') :: interval ))
     </querytext>
   </partialquery>