Re: [GENERAL] regexp_replace - replace non-numbers

2008-10-28 Thread Vincas Dargis
Merlin Moncure wrote: 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 ge

Re: [GENERAL] regexp_replace - replace non-numbers

2008-10-28 Thread Merlin Moncure
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 PR

[GENERAL] regexp_replace - replace non-numbers

2008-10-28 Thread Vincas Dargis
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]&^&*()[]-=" So only thirst assurance where removed, while documentation states