Re: [BUGS] BUG #1618: EXTRACTing EPOCH from TIME WITH TIME ZONE is broken

2005-04-24 Thread Dennis Vshivkov
On Sat, Apr 23, 2005 at 01:58:13AM -0400, Tom Lane wrote: >> Time zone component should be added, not subtracted. > Why? Here's three different ways of looking at the question and seeing that what Postgres is currently doing must be wrong. Correcting the way time zone component is applied fixe

Re: [BUGS] BUG #1618: EXTRACTing EPOCH from TIME WITH TIME ZONE is broken

2005-04-23 Thread Tom Lane
"Dennis Vshivkov" <[EMAIL PROTECTED]> writes: > Time zone component should be added, not subtracted. Done. regards, tom lane ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ? http://www.post

Re: [BUGS] BUG #1618: EXTRACTing EPOCH from TIME WITH TIME ZONE is broken

2005-04-23 Thread Tom Lane
Dennis Vshivkov <[EMAIL PROTECTED]> 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-

Re: [BUGS] BUG #1618: EXTRACTing EPOCH from TIME WITH TIME ZONE is broken

2005-04-22 Thread Tom Lane
"Dennis Vshivkov" <[EMAIL PROTECTED]> writes: > Time zone component should be added, not subtracted. Why? regards, tom lane ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ? http://www.postg

[BUGS] BUG #1618: EXTRACTing EPOCH from TIME WITH TIME ZONE is broken

2005-04-22 Thread Dennis Vshivkov
The following bug has been logged online: Bug reference: 1618 Logged by: Dennis Vshivkov Email address: [EMAIL PROTECTED] PostgreSQL version: 7.4.6, 8.0.1 Operating system: Debian GNU/Linux, kernel 2.4 Description:EXTRACTing EPOCH from TIME WITH TIME ZONE is broken De