On Tue, Jun 30, 2009 at 11:51 AM, James B. Byrne<byrnejb@harte-lyne.ca> wrote:
>
> On Tue, June 30, 2009 13:24, Tom Lane wrote:
>
>>
>> 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
>>
>
> The column is a timestamp value. I expected any time on any given
> date to fall between the start and end of that day so the
> hh:mm:ss:hh portion does not leap out at me as something that should
> cause a problem. Should it?
20080809-01-01 00:00:00
But that timestamp is for the year 20080809, which is pretty far off
in the future. I think that's the problem.