"Merlin Moncure" <[EMAIL PROTECTED]> writes: > # select ((now() - '1 day'::interval)::timestamp - now()) < 0; > ?column? > ---------- > f <-- looks busted to me > (1 row)
If you'd casted to timestamptz then I'd agree this is busted.
As-is, it might have something to do with your timezone setting,
which you didn't mention?
regards, tom lane
---------------------------(end of broadcast)---------------------------
TIP 3: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faq
