[HACKERS] Feature request: -infinity and infinity for date types

[Michael Toews]

Hi,

I hope I found the right list for this request. I am aware that timestamp 
with[out] time zone data types have -infinity and infinity key values; see 
http://www.postgresql.org/docs/current/interactive/datatype-datetime.html

However, there is no equivalent for date types, and expressions like the 
following don't work as expected:
select ('infinity'::timestamp with time zone)::date;

This feature request is for PG to support -infinity and infinity for date 
types. (There is no rush for this feature, as I'm presently using arbitrarily 
large dates like '2099-01-01'::date for this test).

Also, I dug up this same request from 2001:
http://archives.postgresql.org/pgsql-bugs/2001-09/msg00167.php

Thanks for your consideration.

Regards,
-Mike

-- 
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers

Re: [HACKERS] Feature request: -infinity and infinity for date types

[Euler Taveira de Oliveira]

Michael Toews escreveu:
 This feature request is for PG to support -infinity and infinity for date 
 types.
 
This was done for 8.4. Look at TODO [1].


[1] http://wiki.postgresql.org/wiki/Todo


-- 
  Euler Taveira de Oliveira
  http://www.timbira.com/

-- 
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers