"Merlin Moncure" <mmoncure@gmail.com> 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