Re: Match against a column of regexes? - Mailing list pgsql-novice

From Tom Lane
Subject Re: Match against a column of regexes?
Date
Msg-id 27739.1571383617@sss.pgh.pa.us
Whole thread Raw
In response to Match against a column of regexes?  (Stephen Froehlich <s.froehlich@cablelabs.com>)
Responses RE: Match against a column of regexes?
List pgsql-novice
Stephen Froehlich <s.froehlich@cablelabs.com> writes:
> I was wondering if there was an elegant way to match a given string against a column of regexes within PostgreSQL?
I'monly working with a few tens of lines, so I can read them all into R and examine them 1-by-1, but I thought I would
ask.

Something like

    ... WHERE mystring ~ ANY (SELECT regex FROM regexes)

should do.

            regards, tom lane



pgsql-novice by date:

Previous
From: Stephen Froehlich
Date:
Subject: Match against a column of regexes?
Next
From: Stephen Froehlich
Date:
Subject: RE: Match against a column of regexes?