Re: REGEXP: returning match?

--- Jean-Christian Imbeault <jc@mega-bucks.co.jp>
wrote:
> Is there a simple way to get psql to return the part
> that match a query
> containing a regexp?
>

CREATE FUNCTION str_capture(text, text) RETURNS text
AS '
$_[0] =~ m/($_[1])/;
return $1;
' LANGUAGE 'plperl';

__________________________________________________
Do you Yahoo!?
New DSL Internet Access from SBC & Yahoo!
http://sbc.yahoo.com