The following bug has been logged online:
Bug reference: 4284
Logged by: David Rowley
Email address: [EMAIL PROTECTED]
PostgreSQL version: 8.3.3
Operating system: Windows XP and 2003
Description:Optimizer chooses bad plan with LEFT join
Details:
I was asked a few
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
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
