Re: Effecient time ranges in 9.4/9.5?

On 10/4/15 6:18 AM, Karsten Hilbert wrote:
>     check whether both TZs are equal,
>     if so
>         ignore them
>     else
>         convert both operands to UTC,
>     do "time - time",
>     return result AT TIME ZONE UTC,
>     document that UTC is returned,
>
> such that the user can know to apply "AT TIME ZONE ..."
> to the result as needed.

The problem there is you can't reliably convert a time to a different
timezone without knowing what date you're talking about.
--
Jim Nasby, Data Architect, Blue Treble Consulting, Austin TX
Experts in Analytics, Data Architecture and PostgreSQL
Data in Trouble? Get it in Treble! http://BlueTreble.com