Re: 'Infinity' in date columns?
От | Ken Winter |
---|---|
Тема | Re: 'Infinity' in date columns? |
Дата | |
Msg-id | E15398033A2F4F608D2BCC60DF47865D@KenIBM обсуждение исходный текст |
Ответ на | Re: 'Infinity' in date columns? (Tom Lane <tgl@sss.pgh.pa.us>) |
Список | pgsql-general |
> -----Original Message----- > From: pgsql-general-owner@postgresql.org [mailto:pgsql-general- > owner@postgresql.org] On Behalf Of Tom Lane ... > > "Ken Winter" <ken@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
В списке pgsql-general по дате отправления: