On Tue, Oct 28, 2008 at 10:42 AM, Vincas Dargis <[EMAIL PROTECTED]> wrote:
> Hello everyone,
>
> I have problem with regexp_replace ( PostgreSQL 8.3.1). Please try this
> crappy string replacement:
>
> select regexp_replace('[EMAIL PROTECTED]&^&*()[]-=', '[^0-9]*' ,'')
>
> ..and I get:
> "[EMAIL PROTECTED]&^&*()[]-="
>

global flag:
select regexp_replace('[EMAIL PROTECTED]&^&*()[]-=', '[^0-9]*' ,'', 'g');

merlin

-- 
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

Reply via email to