Postgres Pro
Downloads
Home   >   mailing lists

Re: regexp_replace - Mailing list pgsql-general

From Perry Smith
Subject Re: regexp_replace
Date
Msg-id 8CB9C8F0-C3B6-4AD8-8044-1832101EDD49@easesoftware.com
Whole thread Raw
In response to regexp_replace  (polen.t2006@freenet.de)
List pgsql-general
Tree view
On Jul 23, 2007, at 9:50 AM, polen.t2006@freenet.de wrote:
fieldname=regexp_replace(fieldname,old_sub_string,new_sub_string)

Add a 'g' flag:

fieldname=regexp_replace(fieldname,old_sub_string,new_sub_string, 'g')

From the end of a paragraph in 9.7.3 just before 9.7.3.1:

The flags parameter is an optional text string containing zero or more single-letter flags that change the 
function’s behavior. Flag i specifies case-insensitive matching, while flag g specifies replacement of each 
matching substring rather than only the first one. 


Perry Smith ( pedz@easesoftware.com )
Ease Software, Inc. ( http://www.easesoftware.com )

Low cost SATA Disk Systems for IBMs p5, pSeries, and RS/6000 AIX systems


pgsql-general by date:

Previous
From: Michael Fuhr
Date:
Subject: Re: regexp_replace
Next
From: Fst Procurement
Date:
Subject: Re: Connection error