Thom Brown wrote:
> 2010/6/15 Rosi?ski Krzysztof 2 - Detal TP <
> krzysztof.rosins...@telekomunikacja.pl>
>
> > Hello.
> >
> > Operators LIKE and SIMILAR TO work differently
> > This query works ok.:
> >
> > SELECT *
> > FROM www.test
> > WHERE expr like any (ARRAY['a','b']);
> >
> > But this no
=?iso-8859-2?Q?Rosi=F1ski_Krzysztof_2_-_Detal_TP?=
writes:
> Operators LIKE and SIMILAR TO work differently
Yup. It's an implementation restriction (see the comment for
subquery_Op in gram.y if you want to know).
regards, tom lane
--
Sent via pgsql-general mailing lis
2010/6/15 RosiĆski Krzysztof 2 - Detal TP <
krzysztof.rosins...@telekomunikacja.pl>
> Hello.
>
> Operators LIKE and SIMILAR TO work differently
> This query works ok.:
>
> SELECT *
> FROM www.test
> WHERE expr like any (ARRAY['a','b']);
>
> But this not work:
>
> SELECT *
> FROM www.test
> WHE