Received: from localhost (unknown [200.46.204.187]) by postgresql.org (Postfix) with ESMTP id 52DAA2E3704 for ; Wed, 12 Dec 2007 18:35:45 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.187]) (amavisd-maia, port 10024) with ESMTP id 85641-05-3 for ; Wed, 12 Dec 2007 18:35:34 -0400 (AST) Received: from lists.commandprompt.com (host-159.commandprompt.net [207.173.203.159]) by postgresql.org (Postfix) with ESMTP id E6A092E33A5 for ; Wed, 12 Dec 2007 18:35:37 -0400 (AST) Received: from localhost (or-69-34-217-90.sta.embarqhsd.net [69.34.217.90]) (authenticated bits=0) by lists.commandprompt.com (8.13.8/8.13.8) with ESMTP id lBCMZWSH013222 (version=TLSv1/SSLv3 cipher=DHE-RSA-AES256-SHA bits=256 verify=NO); Wed, 12 Dec 2007 14:35:32 -0800 Date: Wed, 12 Dec 2007 14:36:32 -0800 From: "Joshua D. Drake" To: "Medi Montaseri" Cc: pgsql-admin@postgresql.org Subject: Re: WHERE clause OR vs IN Message-ID: <20071212143632.3c742224@commandprompt.com> In-Reply-To: <8078a1730712121425u51dca445j6f8f75468cdeda40@mail.gmail.com> References: <8078a1730712121425u51dca445j6f8f75468cdeda40@mail.gmail.com> Organization: Command Prompt, Inc. X-Mailer: Claws Mail 3.0.2 (GTK+ 2.12.0; x86_64-pc-linux-gnu) Mime-Version: 1.0 Content-Type: text/plain; charset=US-ASCII Content-Transfer-Encoding: base64 X-Greylist: Sender succeeded SMTP AUTH, not delayed by milter-greylist-4.0 (lists.commandprompt.com [207.173.203.159]); Wed, 12 Dec 2007 14:35:32 -0800 (PST) X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200712/72 X-Sequence-Number: 27589 LS0tLS1CRUdJTiBQR1AgU0lHTkVEIE1FU1NBR0UtLS0tLQ0KSGFzaDogU0hBMQ0KDQpPbiBXZWQs IDEyIERlYyAyMDA3IDE0OjI1OjE2IC0wODAwDQoiTWVkaSBNb250YXNlcmkiIDxtb250YXNlcmlA Z21haWwuY29tPiB3cm90ZToNCg0KPiBIaSwNCj4gDQo+IEkga25vdyB0aGlzIGlzIG5vdCBleGFj dGx5IGFkbWluIHJlbGF0ZWQsIGJ1dCAuLi4gaXQgaXMgc2ltcGxlIGVub3VnaA0KPiB0byBiZSBl dmVuIGZ1bg0KPiANCj4gRnJvbSBhIHBlcmZvcm1hbmNlIHBvaW50IG9mIHZpZXcsIGlzIGl0IGJl dHRlciB0byB1c2UgT1IgYXMgaW4NCj4gU0VMRUNUIGV4cHIgRlJPTSBleHByIFdIRVJFIGNvbD10 aGlzIE9SIGNvbD10aGF0IE9SIGNvbD10aGVPdGhlcg0KPiBPciB0byB1c2UgYSByYW5nZSBvZiB2 YWx1ZXMgYXMgaW4NCj4gU0VMRUNUIGV4cHIgRlJPTSBleHByIFdIRVJFIGNvbCBpbiAoIHZhbDEs IHZhbDIsIC4uLi4sIHZhbG4pDQo+IA0KPiBJIHRoaW5rIHRoZSBJTiByYW5nZSB5aWVsZHMgYSBi ZXR0ZXIgcXVlcnkgcGxhbiAuLi4uIHdoYXQgZG8geW91DQo+IHRoaW5rID8gVGhhbmtzDQoNCldl bGwgYSBzaW1wbGUgdGVzdDoNCg0KcG9zdGdyZXM9IyBleHBsYWluIGFuYWx5emUgc2VsZWN0ICog ZnJvbSB0ZWxsZXJzIHdoZXJlIGJpZCBpbiAoJzEnLCcyJyk7DQogICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgUVVFUlkNClBMQU4NCi0gLS0tLS0tLS0tLS0tLS0t LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tDQpTZXEgU2NhbiBvbiB0ZWxsZXJzICAoY29z dD0wLjAwLi4xMC4yNSByb3dzPTIwIHdpZHRoPTM1MikgKGFjdHVhbA0KdGltZT0wLjAxOS4uMC4x OTIgcm93cz0yMCBsb29wcz0xKSBGaWx0ZXI6IChiaWQgPSBBTlkNCignezEsMn0nOjppbnRlZ2Vy W10pKSBUb3RhbCBydW50aW1lOiAwLjMxNCBtcyAoMyByb3dzKQ0KDQpwb3N0Z3Jlcz0jIGV4cGxh aW4gYW5hbHl6ZSBzZWxlY3QgKiBmcm9tIHRlbGxlcnMgd2hlcmUgYmlkID0gJzEnIG9yIGJpZA0K PSAnMic7IFFVRVJZIFBMQU4gICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgDQotIC0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLQ0K IFNlcSBTY2FuIG9uIHRlbGxlcnMgIChjb3N0PTAuMDAuLjExLjUwIHJvd3M9MjAgd2lkdGg9MzUy KSAoYWN0dWFsDQp0aW1lPTAuMDE4Li4wLjE5OSByb3dzPTIwIGxvb3BzPTEpIEZpbHRlcjogKChi aWQgPSAxKSBPUiAoYmlkID0gMikpDQogVG90YWwgcnVudGltZTogMC4yNzUgbXMNCigzIHJvd3Mp DQoNCnBvc3RncmVzPSMgDQoNCg0KDQo+IE1lZGkNCg0KDQotIC0tIA0KVGhlIFBvc3RncmVTUUwg Q29tcGFueTogU2luY2UgMTk5NywgaHR0cDovL3d3dy5jb21tYW5kcHJvbXB0LmNvbS8gDQpTYWxl cy9TdXBwb3J0OiArMS41MDMuNjY3LjQ1NjQgICAyNHg3L0VtZXJnZW5jeTogKzEuODAwLjQ5Mi4y MjQwDQpEb25hdGUgdG8gdGhlIFBvc3RncmVTUUwgUHJvamVjdDogaHR0cDovL3d3dy5wb3N0Z3Jl c3FsLm9yZy9hYm91dC9kb25hdGUNClNFTEVDVCAnVHJhaW5pbmcnLCAnQ29uc3VsdGluZycgRlJP TSB2ZW5kb3IgV0hFUkUgbmFtZSA9ICdDTUQnDQoNCg0KLS0tLS1CRUdJTiBQR1AgU0lHTkFUVVJF LS0tLS0NClZlcnNpb246IEdudVBHIHYxLjQuNiAoR05VL0xpbnV4KQ0KDQppRDhEQlFGSFlHSndB VGIvenFmWlVVUVJBczMyQUo5SHVKVmNZNWdjcjBoYm94a0k2UGNSdHYrK0p3Q2ZYZDAwDQpuUTdG cmtvZjBtVndxTllWeFE5Vnppdz0NCj1YekppDQotLS0tLUVORCBQR1AgU0lHTkFUVVJFLS0tLS0N Cg==