"James B. Byrne" <byrnejb@xxxxxxxxxxxxx> 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 -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
