> -----Original Message----- > From: pgsql-general-ow...@postgresql.org [mailto:pgsql-general- > ow...@postgresql.org] On Behalf Of Tom Lane ... > > "Ken Winter" <k...@sunward.org> writes: > > The documentation at > > http://www.postgresql.org/docs/8.3/static/datatype-datetime.html seems > to > > say that the special value 'infinity' ("later than all other time > stamps") > > should work for an date-time column, and the type "date" is listed as > among > > the date-time data types. > > But I can't get 'infinity' to work for columns of type "date". > > You seem to be carefully reading around the middle column in Table 8-13, > which specifically shows that infinity doesn't work for type date.
Oh, duh, right you are... > Now, if you were to update to Postgres 8.4, it *would* work. I'll see if I can get my host to do that. ~ Thanks ~ Ken -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general