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 Ryan Murphy
Subject Re: [GENERAL] What's the best way in postgres to use ANY() with LIKE '%'?
Date
Msg-id CAHeEsBcFvvXqHasxTPfW6AXU-yKK=9mnfn_zoikwskQLEF=r7A@mail.gmail.com
Whole thread Raw
In response to Re: [GENERAL] What's the best way in postgres to use ANY() with LIKE '%'?  (Hellmuth Vargas <hivs77@gmail.com>)
Responses Re: [GENERAL] What's the best way in postgres to use ANY() with LIKE '%'?  (Thomas Kellerer <spam_eater@gmx.net>)
List pgsql-general
Tree view
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.

Best,
Ryan

On Tue, Sep 5, 2017 at 8:01 AM Hellmuth Vargas <hivs77@gmail.com> wrote:

2017-09-04 22:42 GMT-05:00 Ryan Murphy <ryanfmurphy@gmail.com>:
> I'm pretty sure it doesn't work syntactically.  Don't recall the details offhand.

Ok, thanks!



--
Cordialmente,

Ing. Hellmuth I. Vargas S.
Esp. Telemática y Negocios por Internet 
Oracle Database 10g Administrator Certified Associate
EnterpriseDB Certified PostgreSQL 9.3 Associate

pgsql-general by date:

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