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 Thomas Kellerer
Subject Re: [GENERAL] What's the best way in postgres to use ANY() with LIKE '%'?
Date
Msg-id oomd1l$799$1@blaine.gmane.org
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>)
List pgsql-general
Tree view 
Ryan Murphy schrieb am 05.09.2017 um 16:19:
> Thanks, I saw that page earlier; what I'm looking for is kind of the
> opposite - instead of comparing a single value to see if it matches
> any of a list of patterns, I'm trying to take a list of values and
> see if any of them match a given pattern.
>

You mean something like this?

https://stackoverflow.com/q/46047339/330315

Thomas

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: Steve Atkins
Date:
Subject: Re: [GENERAL] Create Action for psql when NOTIFY Recieved