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 -r1.2
--- openacs-4/contrib/packages/room-reservation/tcl/datetime-procs-postgresql.xql	15 Mar 2004 03:39:30 -0000	1.1
+++ openacs-4/contrib/packages/room-reservation/tcl/datetime-procs-postgresql.xql	12 Sep 2008 14:57:18 -0000	1.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 (timestamp :date > now()) = 't' 
                     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 (timestamp :end_date > timestamp :start_date) = 't' 
                     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 ((now() + interval :future_years) > timestamp :start_date) = 't' 
                     THEN 1
                     ELSE 0
                END