[GENERAL] Inconsistency with LIKE and SIMILAR TO

[Rosiński Krzysztof 2 - Detal TP]

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 ?


pasman

-- 
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general