Re: matching against a list of regexp? - Mailing list pgsql-general

From Richard Broersma
Subject Re: matching against a list of regexp?
Date
Msg-id CABvLTWFpWVjSkQYagj3fjxHqbV2EVY7tw=7DFoBcqpA3ixWonQ@mail.gmail.com
Whole thread Raw
In response to matching against a list of regexp?  ("Gauthier, Dave" <dave.gauthier@intel.com>)
List pgsql-general
On Thu, Oct 27, 2011 at 9:18 AM, Gauthier, Dave <dave.gauthier@intel.com> wrote:
> I need to be able to select all records with a col value that matches any of
> a list of regexp.  Sort of like...
>
> select a,b,c from foo where d ~ ('^xyz','blah','shrug$');

WHERE d ~ '^xyz|blah|shrug$'


--
Regards,
Richard Broersma Jr.

pgsql-general by date:

Previous
From: "Gauthier, Dave"
Date:
Subject: matching against a list of regexp?
Next
From: Venkat Balaji
Date:
Subject: Re: Are pg_xlog/* fiels necessary for PITR?