Re: What's the best way in postgres to use ANY() with LIKE '%'?

From: Ryan Murphy <ryanfmurphy(at)gmail(dot)com>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: What's the best way in postgres to use ANY() with LIKE '%'?
Date: 2017-09-05 03:26:02
Message-ID: CAHeEsBf3aDq9YZ_KUzjhtRpfNWyaaEVqO8dNza63-Ni61QdMOg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

>
> I'm not sure why we've never got round to providing such a thing
> in core ... probably lack of consensus on what to name the reverse
> operator. You'd need to support regex cases as well, so there's
> more than one operator name to come up with.
>

Interesting! It seems like one "simple" possiblity would be to allow ANY()
to be on either side...or would that muck up the Grammar too badly or have
weird edge cases where it doesn't make sense?

>
> regards, tom lane
>

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2017-09-05 03:31:55 Re: What's the best way in postgres to use ANY() with LIKE '%'?
Previous Message Tom Lane 2017-09-05 03:09:15 Re: What's the best way in postgres to use ANY() with LIKE '%'?