Re: BUG #1618: EXTRACTing EPOCH from TIME WITH TIME ZONE is broken - Mailing list pgsql-bugs

From Tom Lane
Subject Re: BUG #1618: EXTRACTing EPOCH from TIME WITH TIME ZONE is broken
Date
Msg-id 10618.1114276320@sss.pgh.pa.us
Whole thread Raw
In response to BUG #1618: EXTRACTing EPOCH from TIME WITH TIME ZONE is broken  ("Dennis Vshivkov" <walrus@amur.ru>)
List pgsql-bugs
Dennis Vshivkov <walrus@amur.ru> writes:
> On Sat, Apr 23, 2005 at 01:58:13AM -0400, Tom Lane wrote:
>>> Time zone component should be added, not subtracted.

>>> Why?

> [ good arguments snipped ]

OK, I'm convinced --- particularly by the point that no place else in
the backend thinks "timetz->time - timetz->zone" is meaningful.

Anyone not think that this should be not only changed, but back-patched
into older branches?  It seems clearly a thinko.

            regards, tom lane

pgsql-bugs by date:

Previous
From: Andrew - Supernews
Date:
Subject: Re: empty array can crash backend using int_array_enum from contrib.
Next
From: Tom Lane
Date:
Subject: Re: V2 protocol -> 8.1 server