There's been work on it. Theodor cleaned it up for HEAD and looked at
adding GiST support. I beleive he's waiting for 8.2 to release.
Yep, I have bundle of patches and I'm waiting for 8.2 branch split out of HEAD.
--
Teodor Sigaev E-mail: [EMAIL PROTECTED]
On Mon, Nov 06, 2006 at 09:10:40PM -0500, JEAN-PIERRE PELLETIER wrote:
I understand that the planner doesn't use indexes for IS NOT DISTINCT FROM,
but it would
be good because is not distinct from is very useful when you have nulls
but don't want to use three value logic.
The main issue is
On Tue, Nov 07, 2006 at 11:03:42AM +0100, Martijn van Oosterhout wrote:
On Mon, Nov 06, 2006 at 09:10:40PM -0500, JEAN-PIERRE PELLETIER wrote:
I understand that the planner doesn't use indexes for IS NOT DISTINCT FROM,
but it would
be good because is not distinct from is very useful when
On Tue, Nov 07, 2006 at 02:12:29PM -0600, Jim C. Nasby wrote:
I assume you're referring to
http://archives.postgresql.org/pgsql-patches/2005-09/msg00083.php ?
I'm curious as to the status of that patch... presumably it never made
it into the queue, but I'm not sure why since you seemed to
@svana.org
Reply-To: Martijn van Oosterhout kleptog@svana.org
To: JEAN-PIERRE PELLETIER [EMAIL PROTECTED]
CC: [EMAIL PROTECTED], pgsql-hackers@postgresql.org
Subject: Re: [HACKERS] Index ignored with is not distinct from, 8.2 beta2
Date: Tue, 7 Nov 2006 11:03:42 +0100
On Mon, Nov 06, 2006 at 09:10:40PM
One issue is that I'm not sure think you've got your sugar quite right.
Have you tested with:
(col IS NOT NULL AND 123 IS NOT NULL AND col = 123) OR
(col IS NULL and 123 IS NULL) ?
It's possible that the planner doesn't know about using an index for
DISTINCT; or it might just want an index
] Index ignored with is not distinct from, 8.2 beta2
Date: Mon, 6 Nov 2006 16:02:40 -0600
One issue is that I'm not sure think you've got your sugar quite right.
Have you tested with:
(col IS NOT NULL AND 123 IS NOT NULL AND col = 123) OR
(col IS NULL and 123 IS NULL) ?
It's possible
I've reposted this from pgsql-performance where I got no response.
==
Hi,
I wanted to use exp1 is not distinct from exp2 which I tough was syntaxic
sugar for
exp1 is not null and exp2 is not null and exp1 = exp2 or exp1 is null and
exp2 is null
but my