both.
David.
- Original Message -
From: "Tom Lane" <[EMAIL PROTECTED]>
To: "David Fetter" <[EMAIL PROTECTED]>
Cc: "David Rowley" <[EMAIL PROTECTED]>;
Sent: Tuesday, March 25, 2008 11:34 PM
Subject: Re: [BUGS] Possible problem with EXTRA
David Fetter <[EMAIL PROTECTED]> writes:
> On Tue, Mar 25, 2008 at 07:50:30PM -, David Rowley wrote:
>> SELECT FLOOR(EXTRACT(EPOCH FROM '2007-04-09 00:59:59'::TIMESTAMP WITHOUT
>> TIME ZONE) / 86400.0),EXTRACT(EPOCH FROM '2007-04-09 00:59:59'::TIMESTAMP
>> WITHOUT TIME ZONE);
> This is a bug
On Tue, Mar 25, 2008 at 07:50:30PM -, David Rowley wrote:
> Hi,
>
> I came across something weird that I personally can't explain regarding the
> EXTRACT function.
> I've created a few SQLs to let people see what is happening. Perhaps there
> is an explaination for it.
>
> Here is my script t
Hi,
I came across something weird that I personally can't explain regarding the
EXTRACT function.
I've created a few SQLs to let people see what is happening. Perhaps there
is an explaination for it.
Here is my script to test:
-- The first column of the following 2 queries is trying to
-- c
