Thread: bug: select date 'infinity' gives error
According to the docs at http://www.postgresql.org/idocs/index.php?datatype-datetime.html, 'infinity' is a valid date input. I quote: "The following SQL-compatible functions can be used as date or time input ... 'infinity' [...]" but I get the following error when trying to set a date to infinity ... $ psql DB -c "select date 'infinity'" ERROR: Unrecognized date external representation 'infinity' whereas it works as as a timestamp ... $ psql DB -c "select timestamp 'infinity'" timestamptz ------------- infinity (1 row) Is my syntax wrong?
Jean-Christian Imbeault <jc@mega-bucks.co.jp> writes: > According to the docs at > http://www.postgresql.org/idocs/index.php?datatype-datetime.html, > 'infinity' is a valid date input. This is a documentation bug. regards, tom lane
Tom Lane wrote: > > This is a documentation bug. Oops, forgot to ask, should I submit a bug report? Or have you taken care of that already? Jc
Tom Lane wrote: > >This is a documentation bug. Shucks ... Is there a way to get an equivalent to infinity for a date? Also, what is the correct way to typecast? I have seen this version "x::data_type" and also while researching infinity for dates "timestamp'infinity'". Is timstamp'infinity' type-casting, or a function call, or ...? Thanks, Jc