Re: BETWEEN not matching on timestamp value - Mailing list pgsql-general

"James B. Byrne" <byrnejb@harte-lyne.ca> writes:
> I have encountered an error that, on the face of it, seems to me to
> be inexplicable.  I hope that someone here can illuminate the matter
> for me.

>       PGError: ERROR:  timestamp out of range: "20080809-01-01
> 00:00:00"
>       : SELECT * FROM "currency_exchange_rates" WHERE
> (currency_code_base = E'CAD' AND currency_code_quote = E'JPY'
> AND effective_from BETWEEN '20080809-01-01 00:00:00' AND
> '20080809-01-01 23:59:59')  ORDER BY currency_code_base,
> currency_code_quote, effective_from DESC

> Now, if I read this aright then, this is telling me that the
> timestamp value I am processing is "20080809-01-01 00:00:00"

No, it's complaining that the constant is out of range --- it's
failing long before it's tried to do any actual BETWEEN comparisons.
Surely you meant something more like 2008-08-09?

            regards, tom lane