Re: regexp question

Andy Kriger writes:

> 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?

Use the substring function.  See the documentation on pattern matching.

-- 
Peter Eisentraut   peter_e@gmx.net