Skip site navigation (1) Skip section navigation (2)

[NOT] (LIKE|ILIKE) (ANY|ALL) (...)

From: Fabien COELHO <coelho(at)cri(dot)ensmp(dot)fr>
To: PostgreSQL Patches <pgsql-patches(at)postgresql(dot)org>
Subject: [NOT] (LIKE|ILIKE) (ANY|ALL) (...)
Date: 2004-03-25 15:42:04
Message-ID: Pine.LNX.4.58.0403251632220.7217@sablons.cri.ensmp.fr (view raw or flat)
Thread:
Lists: pgsql-patches
Dear Patchers,

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,

-- 
Fabien Coelho.

Attachment: like_any.patch
Description: text/plain (3.4 KB)

Responses

pgsql-patches by date

Next:From: Magnus HaganderDate: 2004-03-25 15:54:39
Subject: Re: APC/socket fix (final?)
Previous:From: Andrew DunstanDate: 2004-03-25 13:21:46
Subject: Re: installdir patch for win32

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group