"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. Now, if you were to update to Postgres 8.4, it *would* work. 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
