Please find attached a patch which allows "LIKE/ILIKE/NOT LIKE/NOT ILIKE"
as operators for ANY/SOME/ALL constructs.
SELECT 'foo' LIKE ANY (ARRAY['%a','%o']);
It should also fix some other places where a "~~" operator was allowed,
but not the LIKE operator in the very same place.
However, this patch does not address "SIMILAR TO", as its "hacked"
implementation does not fit the already existing structures for ANY/ALL.
I've added a comment about this in the regression tests.
It validates for me against current CVS head.
Have a nice day,
pgsql-patches by date
|Next:||From: Magnus Hagander||Date: 2004-03-25 15:54:39|
|Subject: Re: APC/socket fix (final?)|
|Previous:||From: Andrew Dunstan||Date: 2004-03-25 13:21:46|
|Subject: Re: installdir patch for win32|