On Mon, Oct 12, 2015 at 12:14:10PM -0500, Jim Nasby wrote: > 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.
I didn't realize we were talking time only. My reading of the thread suggested we were handling timestamps. Karsten -- GPG key ID E4071346 @ eu.pool.sks-keyservers.net E167 67FD A291 2BEA 73BD 4537 78B9 A9F9 E407 1346 -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
