Re: Follow up: range query with timestamp returns different result with index than without (7.3.3)

Christian van der Leeden <lists@logicunited.com> writes:
>     the reason for this misbehaviour was an invalid timestamp value.
> I've tried to dump/restore the db and the restore choked on a
> "incorrect timestamp" namely:
> 4714-11--2147483624 -2147483648:-2147483648:-2147483648 BC

Hmm ... I'm suspecting that that was a "minus infinity" under the hood.
Is your installation built with integer timestamps, or floating point?
(If you're not sure, try "pg_config --configure" and see if it mentions
--enable-integer-datetimes.)  Also, is the column in question of type
timestamp, or timestamp with time zone?

            regards, tom lane