Re: Regex - Mailing list pgsql-general

From Tom Lane
Subject Re: Regex
Date
Msg-id 28900.1139258134@sss.pgh.pa.us
Whole thread Raw
In response to Regex  (MaRCeLO PeReiRA <gandalf_mp@yahoo.com.br>)
Responses Re: Regex  ("rlee0001" <robeddielee@hotmail.com>)
List pgsql-general
MaRCeLO PeReiRA <gandalf_mp@yahoo.com.br> writes:
> Is there a way to execute a regex, inside a SELECT
> statement, to substitute things?

There's a regex_replace() function in recent PG versions.  Or you could
write a function in plperl or pltcl to use the regex capabilities of
those languages.

            regards, tom lane

pgsql-general by date:

Previous
From: MaRCeLO PeReiRA
Date:
Subject: Regex
Next
From: Emi Lu
Date:
Subject: SESSION_USER vs. CURRENT_USER