Re: [GENERAL] Inconsistency with LIKE and SIMILAR TO

2010-06-15 Thread Bruce Momjian
Thom Brown wrote: > 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 no

Re: [GENERAL] Inconsistency with LIKE and SIMILAR TO

2010-06-15 Thread Tom Lane
=?iso-8859-2?Q?Rosi=F1ski_Krzysztof_2_-_Detal_TP?= writes: > Operators LIKE and SIMILAR TO work differently Yup. It's an implementation restriction (see the comment for subquery_Op in gram.y if you want to know). regards, tom lane -- Sent via pgsql-general mailing lis

Re: [GENERAL] Inconsistency with LIKE and SIMILAR TO

2010-06-15 Thread Thom Brown
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 > WHE