Re: [PERFORM] Hypothetical suggestions for planner, indexing improvement - Mailing list pgsql-hackers

From Tom Lane
Subject Re: [PERFORM] Hypothetical suggestions for planner, indexing improvement
Date
Msg-id 24779.1052228707@sss.pgh.pa.us
Whole thread Raw
In response to Hypothetical suggestions for planner, indexing improvement  (Josh Berkus <josh@agliodbs.com>)
Responses Re: [PERFORM] Hypothetical suggestions for planner, indexing  (Dennis Björklund <db@zigo.dhs.org>)
Re: [PERFORM] Hypothetical suggestions for planner, indexing improvement  ("Jim C. Nasby" <jim@nasby.net>)
List pgsql-hackers
"Jim C. Nasby" <jim@nasby.net> writes:
> It would be nice to add support for multi-column IN..
> WHERE (a, b, c) IN (SELECT a, b, c ...)

RTFM...

> BTW, does postgresql handle IN and EXISTS differently?

Yes.

> Theoretically if the optimizer was good enough you could transform one
> to the other and not worry about it.

No.  They have different responses to NULLs in the subselect result.

            regards, tom lane


pgsql-hackers by date:

Previous
From: Patrick Macdonald
Date:
Subject: Re: 7.4 features list
Next
From: Christopher Kings-Lynne
Date:
Subject: Re: [PERFORM] Hypothetical suggestions for planner, indexing