Thread: BUG #14176: Re: BUG #14173: Not using partitions with ANY(ARRAY[...])

VGhlIGZvbGxvd2luZyBidWcgaGFzIGJlZW4gbG9nZ2VkIG9uIHRoZSB3ZWJz
aXRlOgoKQnVnIHJlZmVyZW5jZTogICAgICAxNDE3NgpMb2dnZWQgYnk6ICAg
ICAgICAgIEdhYnJpZWwgZgpFbWFpbCBhZGRyZXNzOiAgICAgIGZ1cnN0ZW5o
ZWltQGdtYWlsLmNvbQpQb3N0Z3JlU1FMIHZlcnNpb246IDkuNS4zCk9wZXJh
dGluZyBzeXN0ZW06ICAgTGludXggNjRiaXQKRGVzY3JpcHRpb246ICAgICAg
ICAKClRoaXMgaXMgYW4gYW5zd2VyIHRvCmh0dHBzOi8vd3d3LnBvc3RncmVz
cWwub3JnL21lc3NhZ2UtaWQvMTI5NTUuMTQ2NDk2Mzc3NSU0MHNzcy5wZ2gu
cGEudXMgDQoNCklmIHRoZSB0eXBlIGlzIGFuIGludGVnZXIgdGhlbiBJIGRv
bid0IGhhdmUgdGhlIHByb2JsZW0uIEhvd2V2ZXIgaWYgSSB1c2UKY2hhcigy
KSB0aGVuIEkgaGF2ZSBpdC4NCg0KY3JlYXRlIHRhYmxlIG10YWJsZSAobXZh
ciBjaGFyICgyKSk7DQpjcmVhdGUgdGFibGUgYzEgKGNoZWNrIChtdmFyID0g
J2FhJykpIGluaGVyaXRzKG10YWJsZSk7DQpjcmVhdGUgdGFibGUgYzIgKGNo
ZWNrIChtdmFyID0gJ2JiJykpIGluaGVyaXRzKG10YWJsZSk7DQpleHBsYWlu
IHNlbGVjdCAqIGZyb20gbXRhYmxlIHdoZXJlIG12YXIgPSAnYWEnOw0KJ0Fw
cGVuZCAoY29zdD0wLjAwLi4zNS41MCByb3dzPTExIHdpZHRoPTEyKScNCicg
LT4gU2VxIFNjYW4gb24gbXRhYmxlIChjb3N0PTAuMDAuLjAuMDAgcm93cz0x
IHdpZHRoPTEyKScNCicgRmlsdGVyOiAobXZhciA9ICdhYSc6OmJwY2hhcikn
DQonIC0+IFNlcSBTY2FuIG9uIGMxIChjb3N0PTAuMDAuLjM1LjUwIHJvd3M9
MTAgd2lkdGg9MTIpJw0KJyBGaWx0ZXI6IChtdmFyID0gJ2FhJzo6YnBjaGFy
KScNCg0KZXhwbGFpbiBzZWxlY3QgKiBmcm9tIG10YWJsZSB3aGVyZSBtdmFy
ID0gYW55IChhcnJheVsnYWEnXSk7DQonQXBwZW5kIChjb3N0PTAuMDAuLjc2
LjEwIHJvd3M9MjEgd2lkdGg9MTIpJw0KJyAtPiBTZXEgU2NhbiBvbiBtdGFi
bGUgKGNvc3Q9MC4wMC4uMC4wMCByb3dzPTEgd2lkdGg9MTIpJw0KJyBGaWx0
ZXI6ICgobXZhcik6OnRleHQgPSBBTlkgKCd7YWF9Jzo6dGV4dFtdKSknDQon
IC0+IFNlcSBTY2FuIG9uIGMxIChjb3N0PTAuMDAuLjM4LjA1IHJvd3M9MTAg
d2lkdGg9MTIpJw0KJyBGaWx0ZXI6ICgobXZhcik6OnRleHQgPSBBTlkgKCd7
YWF9Jzo6dGV4dFtdKSknDQonIC0+IFNlcSBTY2FuIG9uIGMyIChjb3N0PTAu
MDAuLjM4LjA1IHJvd3M9MTAgd2lkdGg9MTIpJw0KJyBGaWx0ZXI6ICgobXZh
cik6OnRleHQgPSBBTlkgKCd7YWF9Jzo6dGV4dFtdKSknDQoNCkN1cmlvdXNs
eSBpZiBJIHVzZSBjaGFyIHZhcnlpbmcoMikgdGhlbiBpdCB3b3JrcyBhcyBl
eHBlY3RlZA0KDQpQUyBzb3JyeSBJIGNhbm5vdCBmaW5kIGhvdyB0byBhbnN3
ZXIgZGlyZWN0bHkgdG8gdGhlIG1haWwKCg==

Hi:

On Fri, Jun 3, 2016 at 6:14 PM,  <furstenheim@gmail.com> wrote:

> If the type is an integer then I don't have the problem. However if I use
> char(2) then I have it.

char tends to do this things. Anyway....

.....
> ' Filter: ((mvar)::text = ANY ('{aa}'::text[]))'

Notice the ::text[]?

> Curiously if I use char varying(2) then it works as expected

Maybe because text[] and varchar[] convert and text[] and char(2)[]
not, you could try to use explicit types ( array['aa'::char(2)] ).
I've seen this happen in other contexts when using char ( unqualified
strings are text, text does not convert that well to char the moment
there is something, like an array[], any() or other function calls,
in the middle ).

> PS sorry I cannot find how to answer directly to the mail

There is alway cut&paste for these things.

Francisco Olarte.