Received: from localhost (maia-2.hub.org [200.46.204.187]) by postgresql.org (Postfix) with ESMTP id 943A19F9280 for ; Mon, 13 Aug 2007 15:27:11 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.187]) (amavisd-maia, port 10024) with ESMTP id 55836-01 for ; Mon, 13 Aug 2007 15:26:58 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.5 Received: from gwmta.wicourts.gov (gwmta.wicourts.gov [165.219.244.99]) by postgresql.org (Postfix) with ESMTP id AB6989F9316 for ; Mon, 13 Aug 2007 15:26:59 -0300 (ADT) Received: from Courts-MTA by gwmta.wicourts.gov with Novell_GroupWise; Mon, 13 Aug 2007 13:26:58 -0500 Message-Id: <46C05C0C.EE98.0025.0@wicourts.gov> X-Mailer: Novell GroupWise Internet Agent 7.0.2 Date: Mon, 13 Aug 2007 13:26:41 -0500 From: "Kevin Grittner" To: "Steve Holdoway" , Subject: Re: except command References: <46C099F6.8050002@cerene.fr> <46C0579F.EE98.0025.0@wicourts.gov> <20070814061358.d66d2cb3.steve.holdoway@firetrust.com> In-Reply-To: <20070814061358.d66d2cb3.steve.holdoway@firetrust.com> Mime-Version: 1.0 Content-Type: text/plain; charset=US-ASCII Content-Transfer-Encoding: quoted-printable Content-Disposition: inline X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200708/135 X-Sequence-Number: 26466 >>> On Mon, Aug 13, 2007 at 1:13 PM, in message <20070814061358.d66d2cb3.steve.holdoway@firetrust.com>, Steve Holdoway wrote:=20 > 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. =20 -Kevin =20