Re: [HACKERS] Returning 'Infinity'::TIMESTAMPTZ from "to_timestamp" function

FYI, I show this as fixed in 9.6: test=> SELECT to_timestamp('Infinity'::float); to_timestamp -- infinity (1 row) --- On Sun, Nov 8, 2015 at 09:15:16PM -0800, Vitaly

Re: [HACKERS] Returning 'Infinity'::TIMESTAMPTZ from "to_timestamp" function

Vitaly Burovoy writes: > To add an ability to construct 'Infinity' TIMESTAMPTZ via > "to_timestamp" call, there are two ways: > 1. Rewrite the function "pg_catalog.to_timestamp(double precision)" as > an internal one. It's the easiest way, because it allows to avoid >

[HACKERS] Returning 'Infinity'::TIMESTAMPTZ from "to_timestamp" function

Hello everyone! Continuing the topic of extracting EPOCH from 'Infinity'::TIMESTAMPTZ and according to an item "converting between infinity timestamp and float8" in the TODO list... Even when "SELECT extract(EPOCH FROM TIMESTAMPTZ 'Infinity')" results 'Infinity'::float, there is still trouble to