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 > 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? Thom
