Thanks for your explanation
And your small example was better as one page documentation
I was totally wrong.
So it's like a filter on the first query
I think it's useful when we have complex queries .
Olivier
Kevin Grittner a écrit :
On Mon, Aug 13, 2007 at 1:13 PM, in message
<20070814061358.d66d2cb3.steve.holdoway@xxxxxxxxxxxxx>, Steve Holdoway
<steve.holdoway@xxxxxxxxxxxxx> wrote:
On Mon, 13 Aug 2007 13:07:43 -0500
"Kevin Grittner" <Kevin.Grittner@xxxxxxxxxxxx> wrote:
This gets me all the eye color codes that don't start with the letter 'B'.
(There are of course easier ways to get that...)
so is this faster than usiung 'where not exists' ??
I was trying to show a valid use of EXCEPT, not an alternative.
-Kevin
---------------------------(end of broadcast)---------------------------
TIP 7: You can help support the PostgreSQL project by donating at
http://www.postgresql.org/about/donate
---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match
