Postgres Pro
Downloads
Home   >   mailing lists

Re: Follow up: range query with timestamp returns different result with index than without (7.3.3) - Mailing list pgsql-bugs

From Tom Lane
Subject Re: Follow up: range query with timestamp returns different result with index than without (7.3.3)
Date
Msg-id 15202.1060266196@sss.pgh.pa.us
Whole thread Raw
In response to Follow up: range query with timestamp returns different result with index than without (7.3.3)  (Christian van der Leeden <lists@logicunited.com>)
Responses Re: Follow up: range query with timestamp returns different result with index than without (7.3.3)
List pgsql-bugs
Tree view 
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

pgsql-bugs by date:

Previous
From: Tom Lane
Date:
Subject: Re: range query with timestamp returns different result with index than without (7.3.3)
Next
From: Troels Arvin
Date:
Subject: Non-standard TIMESTAMP WITH TIME ZONE literal handling