Received: from localhost (maia-1.hub.org [200.46.204.191]) by postgresql.org (Postfix) with ESMTP id D17559F9C5A for ; Mon, 13 Aug 2007 18:30:40 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.191]) (amavisd-maia, port 10024) with ESMTP id 27428-05 for ; Mon, 13 Aug 2007 18:30:38 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.5 Received: from mx.imatech.net (mx.imatech.net [81.255.215.253]) by postgresql.org (Postfix) with ESMTP id 6CE2D9F94B4 for ; Mon, 13 Aug 2007 18:30:37 -0300 (ADT) X-AuthUser: olivier.boissard@cerene.fr Received: from [192.168.0.10] ([88.161.145.183]:3123) by mx.imatech.net with [XMail 1.23 ESMTP Server] id for from ; Mon, 13 Aug 2007 23:30:27 +0200 Message-ID: <46C0CD72.5090407@cerene.fr> Date: Mon, 13 Aug 2007 23:30:26 +0200 From: "olivier.boissard@cerene.fr" User-Agent: Thunderbird 1.5.0.12 (Windows/20070509) MIME-Version: 1.0 To: Kevin Grittner , pgsql-admin@postgresql.org CC: Steve Holdoway Subject: Re: except command References: <46C099F6.8050002@cerene.fr> <46C0579F.EE98.0025.0@wicourts.gov> <20070814061358.d66d2cb3.steve.holdoway@firetrust.com> <46C05C0C.EE98.0025.0@wicourts.gov> In-Reply-To: <46C05C0C.EE98.0025.0@wicourts.gov> Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 8bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200708/142 X-Sequence-Number: 26473 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@firetrust.com>, Steve Holdoway > wrote: > >> On Mon, 13 Aug 2007 13:07:43 -0500 >> "Kevin Grittner" 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 > >