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

From: Fabien COELHO <coelho(at)cri(dot)ensmp(dot)fr>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: PostgreSQL Patches <pgsql-patches(at)postgresql(dot)org>
Subject: Re: [NOT] (LIKE|ILIKE) (ANY|ALL) (...)
Date: 2004-03-26 07:05:01
Message-ID: Pine.GSO.4.58.0403260801010.4712@elvis
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-patches


> Fabien COELHO <coelho(at)cri(dot)ensmp(dot)fr> writes:
> > Please find attached a patch which allows "LIKE/ILIKE/NOT LIKE/NOT ILIKE"
> > as operators for ANY/SOME/ALL constructs.
>
> This seems to allow a whole lot of unintended and probably uncool things
> as well. "ORDER BY NOT LIKE", for instance.

Yes.

Well, it seemed to me (maybe I'm wrong here/) that "ORDER BY !~~" was
allowed anyway by the parser, so I cannot see why it should not allow "NOT
LIKE" as well, even if it does not make sense. I guess that it is filtered
out later anyway?

Or the rule factorization must be changed. It can also be done.

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

In response to

Responses

Browse pgsql-patches by date

  From Date Subject
Next Message Tom Lane 2004-03-26 14:51:57 Re: [NOT] (LIKE|ILIKE) (ANY|ALL) (...)
Previous Message Claudio Natoli 2004-03-26 03:35:06 Re: installdir patch for win32