Re: Inconsistency with LIKE and SIMILAR TO

Thom Brown wrote:
> 2010/6/15 Rosi?ski Krzysztof 2 - Detal TP <
> Krzysztof(dot)Rosinski2(at)telekomunikacja(dot)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(at)momjian(dot)us> http://momjian.us
EnterpriseDB http://enterprisedb.com

+ None of us is going to be here forever. +