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