Thom Brown wrote:
> 2010/6/15 Rosi?ski Krzysztof 2 - Detal TP <
> Krzysztof.Rosinski2@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
> > WHERE expr similar to any (ARRAY['a','b']);
> >
> > ERROR: syntax error at or near "any"
> > LINE 3: WHERE expr similar to any (ARRAY['a','b']);
> >
> > Is this shouldn't works ?
> >
> >
> SIMILAR TO and LIKE aren't synonyms for each other. SIMILAR TO uses a cross
> between LIKE syntax and regular expressions for the evalutated expression.
> I'm not entirely sure what your query is supposed to be doing. I thought
> ANY was a keyword denoting a row-wise comparison?
LIKE is only similar to SIMILAR TO. ;-)
--
Bruce Momjian <bruce@momjian.us> http://momjian.us
EnterpriseDB http://enterprisedb.com
+ None of us is going to be here forever. +