Received: from makus.postgresql.org ([98.129.198.125]) by malur.postgresql.org with esmtp (Exim 4.72) (envelope-from ) id 1TE0Y1-0007oB-6U for pgsql-committers@postgresql.org; Tue, 18 Sep 2012 16:21:17 +0000 Received: from mahout.postgresql.org ([98.129.198.123]) by makus.postgresql.org with esmtp (Exim 4.72) (envelope-from ) id 1TE0Xy-0006Mv-Ru for pgsql-committers@postgresql.org; Tue, 18 Sep 2012 16:21:16 +0000 Received: from [98.129.198.116] (helo=gemulon.postgresql.org) by mahout.postgresql.org with esmtp (Exim 4.72) (envelope-from ) id 1TE0Xy-0008AA-HD for pgsql-committers@postgresql.org; Tue, 18 Sep 2012 16:21:14 +0000 Received: from git by gemulon.postgresql.org with local (Exim 4.72) (envelope-from ) id 1TE0Xy-0006tu-6a for pgsql-committers@postgresql.org; Tue, 18 Sep 2012 16:21:14 +0000 Date: Tue, 18 Sep 2012 16:21:14 +0000 Message-Id: Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 To: pgsql-committers@postgresql.org From: Tom Lane Subject: pgsql: Fix planning of btree index scans using ScalarArrayOpExpr quals. X-Pg-Spam-Score: -2.4 (--) X-Archive-Number: 201209/177 X-Sequence-Number: 49220 Rml4IHBsYW5uaW5nIG9mIGJ0cmVlIGluZGV4IHNjYW5zIHVzaW5nIFNjYWxhckFycmF5T3BFeHBy IHF1YWxzLgoKSW4gY29tbWl0IDllOGRhMGY3NTczMWFhYTc2MDVjZjQ2NTZjMjFlYTA5ZTg0ZDJl YjEsIEkgaW1wcm92ZWQgYnRyZWUKdG8gaGFuZGxlIFNjYWxhckFycmF5T3BFeHByIHF1YWxzIG5h dGl2ZWx5LCBzbyB0aGF0IGNvbnN0cnVjdHMgbGlrZQoiaW5kZXhlZGNvbCBJTiAobGlzdCkiIGNv dWxkIGJlIHN1cHBvcnRlZCBieSBpbmRleC1vbmx5IHNjYW5zLiAgVXNpbmcKc3VjaCBhIHF1YWwg cmVzdWx0cyBpbiBtdWx0aXBsZSBzY2FucyBvZiB0aGUgaW5kZXgsIHVuZGVyLXRoZS1ob29kLgpJ IHdlbnQgdG8gc29tZSBsZW5ndGhzIHRvIGVuc3VyZSB0aGF0IHRoaXMgc3RpbGwgcHJvZHVjZXMg cm93cyBpbiBpbmRleApvcmRlciAuLi4gYnV0IEkgZmFpbGVkIHRvIHJlY29nbml6ZSB0aGF0IGlm IGEgaGlnaGVyLW9yZGVyIGluZGV4IGNvbHVtbgppcyBsYWNraW5nIGFuIGVxdWFsaXR5IGNvbnN0 cmFpbnQsIHJlc2NhbnMgY2FuIHByb2R1Y2Ugb3V0LW9mLW9yZGVyCmRhdGEgZnJvbSB0aGF0IGNv bHVtbi4gIFR3ZWFrIHRoZSBwbGFubmVyIHRvIG5vdCBleHBlY3Qgc29ydGVkIG91dHB1dAppbiB0 aGF0IGNhc2UuICBQZXIgdHJvdWJsZSByZXBvcnQgZnJvbSBSb2JlcnQgTWNHZWhlZS4KCkJyYW5j aAotLS0tLS0KUkVMOV8yX1NUQUJMRQoKRGV0YWlscwotLS0tLS0tCmh0dHA6Ly9naXQucG9zdGdy ZXNxbC5vcmcvcGcvY29tbWl0ZGlmZi8zY2NjYzY5OTBiNjYyNjVhZDdjNGJmYmU1Nzg5Y2U1NzFh MzlkODc2CgpNb2RpZmllZCBGaWxlcwotLS0tLS0tLS0tLS0tLQpzcmMvYmFja2VuZC9vcHRpbWl6 ZXIvcGF0aC9pbmR4cGF0aC5jICAgICAgfCAgIDE1ICsrKysrKysrLQpzcmMvdGVzdC9yZWdyZXNz L2V4cGVjdGVkL2NyZWF0ZV9pbmRleC5vdXQgfCAgIDQ1ICsrKysrKysrKysrKysrKysrKysrKysr KysrKysKc3JjL3Rlc3QvcmVncmVzcy9zcWwvY3JlYXRlX2luZGV4LnNxbCAgICAgIHwgICAyNCAr KysrKysrKysrKysrKysKMyBmaWxlcyBjaGFuZ2VkLCA4MyBpbnNlcnRpb25zKCspLCAxIGRlbGV0 aW9ucygtKQoK