Index: openacs-4/contrib/packages/room-reservation/tcl/datetime-procs-postgresql.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/contrib/packages/room-reservation/tcl/datetime-procs-postgresql.xql,v
diff -u -r1.1.4.1 -r1.1.4.2
--- openacs-4/contrib/packages/room-reservation/tcl/datetime-procs-postgresql.xql	12 Jul 2004 22:08:42 -0000	1.1.4.1
+++ openacs-4/contrib/packages/room-reservation/tcl/datetime-procs-postgresql.xql	10 Jun 2005 22:44:24 -0000	1.1.4.2
@@ -6,7 +6,7 @@
 
     <fullquery name="room-reservation::datetime::check_valid_end_date_p.valid_p">
       <querytext>
-        select CASE WHEN (now() - :date::timestamp) < 0 
+        select CASE WHEN now() < :date::timestamp
                     THEN 1
                     ELSE 0
                END 
@@ -16,7 +16,7 @@
 
     <fullquery name="room-reservation::datetime::check_valid_dates_p.valid_p">
       <querytext>
-        select CASE WHEN (:start_date::timestamp - :end_date::timestamp) < 0 
+        select CASE WHEN :start_date::timestamp < :end_date::timestamp
                     THEN 1
                     ELSE 0
                END 
@@ -26,7 +26,7 @@
 
     <fullquery name="room-reservation::datetime::check_valid_year_p.valid_p">
       <querytext>
-        select CASE WHEN (:start_date::timestamp - (now() + :future_years)) < 0 
+        select CASE WHEN :start_date::timestamp < now() + :future_years
                     THEN 1
                     ELSE 0
                END