Re: Inconsistency with LIKE and SIMILAR TO

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. +