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
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 |