Re: [PATCHES] regexp_replace
От | Atsushi Ogawa |
---|---|
Тема | Re: [PATCHES] regexp_replace |
Дата | |
Msg-id | PIEMIKOOMKNIJLLLBCBBGECMCIAA.a_ogawa@hi-ho.ne.jp обсуждение исходный текст |
Ответ на | Re: [PATCHES] regexp_replace (Bruce Momjian <pgman@candle.pha.pa.us>) |
Ответы |
Re: [PATCHES] regexp_replace
|
Список | pgsql-hackers |
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
В списке pgsql-hackers по дате отправления: