Re: [BUGS] extract(epoch from infinity) is not 0 - Mailing list 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