regexp question

From: "Andy Kriger" <akriger(at)greaterthanone(dot)com>
To: "Pgsql-General" <pgsql-general(at)postgresql(dot)org>
Subject: regexp question
Date: 2003-02-21 20:48:45
Message-ID: OJEFIHHAALOBKKJEOMBDEENEDHAA.akriger@greaterthanone.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Robert Treat 2003-02-21 22:10:09 Re: Non-English lists and User Groups
Previous Message Dmitry Tkach 2003-02-21 20:47:19 Re: A problem with sequences...