Re: Regular expressions in procs - Mailing list pgsql-general

From Albe Laurenz
Subject Re: Regular expressions in procs
Date
Msg-id AFCCBB403D7E7A4581E48F20AF3E5DB2035FB95C@EXADV1.host.magwien.gv.at
Whole thread Raw
In response to Regular expressions in procs  (Steve Manes <smanes@magpie.com>)
List pgsql-general
Steve Manes wrote:
> I apologize if I'm having a rookie brain block, but is there a way to
> massage a string inside a proc to, for instance, strip it of all
> non-alpha characters using a regular expression?

SELECT regexp_replace(E'--> text\\\0120815_12 <--', '[^[:alpha:]]', '',
'g');
 regexp_replace
----------------
 text
(1 row)

Yours,
Laurenz Albe

pgsql-general by date:

Previous
From: "Manso Gomez, Ramon"
Date:
Subject: Re: [SQL] setof or array as input parameter to postgresql 8.2 functions
Next
From: "Pavel Stehule"
Date:
Subject: Re: inner join problem with temporary tables