LIKE ANY and the like?

From: Fabien COELHO <coelho(at)cri(dot)ensmp(dot)fr>
To: PostgreSQL Developers <pgsql-hackers(at)postgresql(dot)org>
Subject: LIKE ANY and the like?
Date: 2004-03-23 08:52:45
Message-ID: Pine.LNX.4.58.0403230853420.7217@sablons.cri.ensmp.fr
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers


Dear hackers,

a small inconsistency with the syntax of any/all as describe from the
documentation. One can write:

psql> SELECT 'foo' ~~ ANY (ARRAY['%a%','%o%']);

although the following yields a syntax error, even if LIKE is an operator,
thus it should be allowed.

psql> SELECT 'foo' LIKE ANY (ARRAY['%a%','%o%']);

IMHO, it would make sense to allow the later unless some critical parser
implication, as an average user (say, me;-) would try that before the
first one.

=> Add to todo list?

Have a nice day,

--
Fabien Coelho - coelho(at)cri(dot)ensmp(dot)fr

Browse pgsql-hackers by date

  From Date Subject
Next Message Neil Conway 2004-03-23 10:00:14 linked list rewrite
Previous Message Christopher Kings-Lynne 2004-03-23 07:34:39 Re: bug in 7.4 SET WITHOUT OIDs