matching against a list of regexp?

From: "Gauthier, Dave" <dave(dot)gauthier(at)intel(dot)com>
To: pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject: matching against a list of regexp?
Date: 2011-10-27 16:18:01
Message-ID: 482E80323A35A54498B8B70FF2B8798004D5AB1CF1@azsmsx504.amr.corp.intel.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi:

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$');

Does anyone know the right syntax for this?

Thanks!

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Richard Broersma 2011-10-27 16:21:31 Re: matching against a list of regexp?
Previous Message Ben Chobot 2011-10-27 14:50:47 Re: WAL file size vs. data file size