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