Thom Brown wrote: > 2010/6/15 Rosi?ski Krzysztof 2 - Detal TP < > Krzysztof.Rosinski2@xxxxxxxxxxxxxxxxxx> > > > 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@xxxxxxxxxx> http://momjian.us EnterpriseDB http://enterprisedb.com + None of us is going to be here forever. + -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
