Re: Effecient time ranges in 9.4/9.5?

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