Re: [BUGS] extract(epoch from infinity) is not 0

From: Josh Berkus <josh(at)agliodbs(dot)com>
To: pgsql-hackers(at)postgresql(dot)org
Subject: Re: [BUGS] extract(epoch from infinity) is not 0
Date: 2011-07-13 21:22:26
Message-ID: 4E1E0C92.40205@agliodbs.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs pgsql-hackers


> It's sort of non-obvious that either behavior is better than the other.

Here's the reason why the existing behavior is wrong:

postgres=# select extract('epoch' from timestamptz 'infinity') = extract
('epoch' from timestamptz '1970-01-01 00:00:00-00');
?column?
----------
t

--
Josh Berkus
PostgreSQL Experts Inc.
http://pgexperts.com

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message Tom Lane 2011-07-13 21:22:36 Re: [BUGS] extract(epoch from infinity) is not 0
Previous Message Brendan Jurd 2011-07-13 21:21:22 Re: [BUGS] extract(epoch from infinity) is not 0

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2011-07-13 21:22:36 Re: [BUGS] extract(epoch from infinity) is not 0
Previous Message Brendan Jurd 2011-07-13 21:21:22 Re: [BUGS] extract(epoch from infinity) is not 0