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.