bug: select date 'infinity' gives error - Mailing list pgsql-general

From Jean-Christian Imbeault
Subject bug: select date 'infinity' gives error
Date
Msg-id 3DDC7657.8070703@mega-bucks.co.jp
Whole thread Raw
Responses Re: bug: select date 'infinity' gives error  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
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?



pgsql-general by date:

Previous
From: Andrew Magnus
Date:
Subject: &main::execute undefined?
Next
From: "Thomas T. Thai"
Date:
Subject: double quotes around table and column names