Re: except command

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(dot)d66d2cb3(dot)steve(dot)holdoway(at)firetrust(dot)com>, Steve Holdoway
> <steve(dot)holdoway(at)firetrust(dot)com> wrote:
>
>> On Mon, 13 Aug 2007 13:07:43 -0500
>> "Kevin Grittner" <Kevin(dot)Grittner(at)wicourts(dot)gov> 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
>
>