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