Index: openacs-4/packages/ecommerce/www/admin/customer-service/issues-postgresql.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/ecommerce/www/admin/customer-service/issues-postgresql.xql,v
diff -u -r1.1 -r1.2
--- openacs-4/packages/ecommerce/www/admin/customer-service/issues-postgresql.xql	15 Jul 2001 20:30:12 -0000	1.1
+++ openacs-4/packages/ecommerce/www/admin/customer-service/issues-postgresql.xql	22 Jul 2001 07:05:36 -0000	1.2
@@ -5,20 +5,20 @@
 
 <partialquery name="last_24">
       <querytext>
-	and now()-i.open_date <= 1
+	and now()-i.open_date <= timespan_days(1)
       </querytext>
 </partialquery>
 
 
 <partialquery name="last_week">
       <querytext>
-	and now()-i.open_date <= 7
+	and now()-i.open_date <= timespan_days(7)
       </querytext>
 </partialquery>
 
 <partialquery name="last_month">
       <querytext>
-	and extract(month from now()) - extract(month from i.open_date) <= 1
+	and now()-i.open_date <= '1 month'::interval
       </querytext>
 </partialquery>