regexp question - Mailing list pgsql-general

From Andy Kriger
Subject regexp question
Date
Msg-id OJEFIHHAALOBKKJEOMBDEENEDHAA.akriger@greaterthanone.com
Whole thread Raw
Responses Re: regexp question  (Peter Eisentraut <peter_e@gmx.net>)
Re: regexp question  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
I see that it's possible to select using regexps.
Is it possible to use portions of the selection in the result?

example...
select * from table where column ~ '.*\(blah.*\)'
will return any row with characters-blah-characters

Is there any way I can get just the blah.* portion of the string in my
result?

thx
andy



pgsql-general by date:

Previous
From: "scott.marlowe"
Date:
Subject: Re: Problem with functional indexes
Next
From: Stephan Szabo
Date:
Subject: Re: Mutating table (urgent)