Feature request: -infinity and infinity for date types

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: Raw Message | Whole Thread | 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

Responses

Browse pgsql-hackers by date

  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