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


--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

Reply via email to