Feature request: -infinity and infinity for date types

Started by Michael Toewsalmost 17 years ago2 messages
#1Michael Toews
mwtoews@sfu.ca

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

In reply to: Michael Toews (#1)
Re: Feature request: -infinity and infinity for date types

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]http://wiki.postgresql.org/wiki/Todo.

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

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