On Tue, Oct 28, 2008 at 10:42 AM, Vincas Dargis <vincas(dot)d(at)nensis(dot)lt> wrote:
> Hello everyone,
>
> I have problem with regexp_replace ( PostgreSQL 8.3.1). Please try this
> crappy string replacement:
>
> select regexp_replace('abcd1235hgj!(at)#$^&^&*()[]-=', '[^0-9]*' ,'')
>
> ..and I get:
> "1235hgj!(at)#$^&^&*()[]-="
>
global flag:
select regexp_replace('abcd1235hgj!(at)#$^&^&*()[]-=', '[^0-9]*' ,'', 'g');
merlin