> -----Original Message----- > From: pgsql-general-owner@xxxxxxxxxxxxxx [mailto:pgsql-general- > owner@xxxxxxxxxxxxxx] On Behalf Of Tom Lane ... > > "Ken Winter" <ken@xxxxxxxxxxx> 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@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
