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

From: Thomas Kellerer <spam_eater(at)gmx(dot)net>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: What's the best way in postgres to use ANY() with LIKE '%'?
Date: 2017-09-05 14:41:01
Message-ID: oomd1l$799$1@blaine.gmane.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Steve Atkins 2017-09-05 15:19:13 Re: Create Action for psql when NOTIFY Recieved
Previous Message Ryan Murphy 2017-09-05 14:19:22 Re: What's the best way in postgres to use ANY() with LIKE '%'?