"Merlin Moncure" <mmoncure@xxxxxxxxx> 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
