| From: | "olivier(dot)boissard(at)cerene(dot)fr" <olivier(dot)boissard(at)cerene(dot)fr> |
|---|---|
| To: | Kevin Grittner <Kevin(dot)Grittner(at)wicourts(dot)gov>, pgsql-admin(at)postgresql(dot)org |
| Cc: | Steve Holdoway <steve(dot)holdoway(at)firetrust(dot)com> |
| Subject: | Re: except command |
| Date: | 2007-08-13 21:30:26 |
| Message-ID: | 46C0CD72.5090407@cerene.fr |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin |
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
>
>
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tena Sakai | 2007-08-13 21:51:46 | postmaster.pid file |
| Previous Message | Tom Lane | 2007-08-13 21:06:10 | Re: plpgsql question/problem |