Index: openacs-4/contrib/packages/room-reservation/tcl/room-reservation-procs-postgresql.xql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/contrib/packages/room-reservation/tcl/room-reservation-procs-postgresql.xql,v diff -u -r1.1.4.1 -r1.1.4.2 --- openacs-4/contrib/packages/room-reservation/tcl/room-reservation-procs-postgresql.xql 12 Jul 2004 22:08:42 -0000 1.1.4.1 +++ openacs-4/contrib/packages/room-reservation/tcl/room-reservation-procs-postgresql.xql 9 Sep 2004 18:56:59 -0000 1.1.4.2 @@ -13,7 +13,7 @@ on (s.interval_id = t.interval_id) join rr_reservations r on (e.event_id = r.reservation_id) - where end_date < (now() - to_number(:expiry_days,'999')); + where end_date < (current_timestamp - :expiry_days::INTERVAL);