| From: | Michael Toews <mwtoews(at)sfu(dot)ca> |
|---|---|
| To: | pgsql-hackers(at)postgresql(dot)org |
| Subject: | Feature request: -infinity and infinity for date types |
| Date: | 2009-03-25 23:03:12 |
| Message-ID: | 478179473.1891971238022192842.JavaMail.root@jaguar9.sfu.ca |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Euler Taveira de Oliveira | 2009-03-25 23:13:49 | Re: Feature request: -infinity and infinity for date types |
| Previous Message | Tom Lane | 2009-03-25 22:27:20 | Re: Review: B-Tree emulation for GIN |