Re: maybe incorrect regexp_replace behavior in v8.3.4 ?

Поиск
Список
Период
Сортировка
Искать
От
Tom Lane
Тема
Re: maybe incorrect regexp_replace behavior in v8.3.4 ?
Дата
в 11:16:03
Msg-id
24763.1337177745@sss.pgh.pa.us
Ответ на
Список
Дерево обсуждения
maybe incorrect regexp_replace behavior in v8.3.4 ? "Gauthier, Dave" <dave.gauthier@intel.com>
Re: maybe incorrect regexp_replace behavior in v8.3.4 ? Tom Lane <tgl@sss.pgh.pa.us>
Re: maybe incorrect regexp_replace behavior in v8.3.4 ? Richard Huxton <dev@archonet.com>
"Gauthier, Dave"  writes:
> bi_hsx_a0_latest=# select regexp_replace('xxx','^xxxy$',null);
> regexp_replace
> ----------------
>
> (1 row)
> But why did it return null in this case?

regexp_replace is strict, so it never even gets called when there's
a null input.

			regards, tom lane
В списке pgsql-general по дате отправления
От: Richard Huxton
Дата:
От: Tom Lane
Дата:
FAQ