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

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

pgsql-general by date:

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