Atsushi Ogawa wrote: > I think that it is good to specify the flags by one character as well > as Perl. > > I propose the following specification: > > regexp_replace(source text, pattern text, replacement text, [flags text]) > returns text > > The flags can use the following values: > g: global (replace all) > i: ignore case > > When the flags is not specified, case sensitive, replace the first > instance only.
This seems good to me. -- Bruce Momjian | http://candle.pha.pa.us pgman@candle.pha.pa.us | (610) 359-1001 + If your life is a hard drive, | 13 Roberts Road + Christ can be your backup. | Newtown Square, Pennsylvania 19073 ---------------------------(end of broadcast)--------------------------- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq