Postgres Pro
Downloads
Home   >   mailing lists

Re: [GENERAL] What's the best way in postgres to use ANY() with LIKE '%'? - Mailing list pgsql-general

From Tom Lane
Subject Re: [GENERAL] What's the best way in postgres to use ANY() with LIKE '%'?
Date
Msg-id 31162.1504582315@sss.pgh.pa.us
Whole thread Raw
In response to Re: [GENERAL] What's the best way in postgres to use ANY() with LIKE '%'?  (Ryan Murphy <ryanfmurphy@gmail.com>)
Responses Re: [GENERAL] What's the best way in postgres to use ANY() with LIKE '%'?  (Ryan Murphy <ryanfmurphy@gmail.com>)
List pgsql-general
Tree view 
Ryan Murphy <ryanfmurphy@gmail.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

pgsql-general by date:

Previous
From: Ryan Murphy
Date:
Subject: Re: [GENERAL] What's the best way in postgres to use ANY() with LIKE '%'?
Next
From: Ryan Murphy
Date:
Subject: Re: [GENERAL] What's the best way in postgres to use ANY() with LIKE '%'?