We updated our production server to postgresql 8.2.3 yesterday. This query is giving different results than on our development box: development: # select ((now() - '1 day'::interval)::timestamp - now()) < 0; ?column? ---------- t (1 row) production # select ((now() - '1 day'::interval)::timestamp - now()) < 0; ?column? ---------- f <-- looks busted to me (1 row) both servers are redhat fc4, same version postgresql. only difference I know of is development is a little behind on yum update. can anybody think of anything that might have influenced this? merlin