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

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Ryan Murphy <ryanfmurphy(at)gmail(dot)com>
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:31:55
Message-ID: 31162.1504582315@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Ryan Murphy <ryanfmurphy(at)gmail(dot)com> writes:
> 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?

I'm pretty sure it doesn't work syntactically. Don't recall the details
offhand.

regards, tom lane

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Ryan Murphy 2017-09-05 03:42:52 Re: What's the best way in postgres to use ANY() with LIKE '%'?
Previous Message Ryan Murphy 2017-09-05 03:26:02 Re: What's the best way in postgres to use ANY() with LIKE '%'?