On Tue, Jun 30, 2009 at 11:51 AM, James B. Byrne<byrnejb@xxxxxxxxxxxxx> 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. -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
