Tom Flavel wrote: > On 08/06/2005 21:57:29, Bruce Momjian wrote: > > Andrew Dunstan wrote: > > > > > > surely somthing like > > > > > > foo_replace (source text, pattern text, replacement text, flags text) > > > returns text > > > > > > would fit the bill. OK, it reflects my Perl prejudices, but that > > > looks more natural to me. You could overload it so that the flags > > > default to none > > > (which would be case sensitive, replace the first instance only, > > > among other things). > > > > Can we have the flags be a list of words, e.g. "all, ignorecase". How > > do we handle this type of problem in other cases? > > How about an array? > > Cumbersome, perhaps, but it makes more sense to me than delimiting with > commas or using single characters.
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. regards, --- Atsushi Ogawa ---------------------------(end of broadcast)--------------------------- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])