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