maybe incorrect regexp_replace behavior in v8.3.4 ?

Поиск
Список
Период
Сортировка
От Gauthier, Dave
Тема maybe incorrect regexp_replace behavior in v8.3.4 ?
Дата
Msg-id 0AD01C53605506449BA127FB8B99E5E10F18731A@FMSMSX105.amr.corp.intel.com
обсуждение исходный текст
Ответы Re: maybe incorrect regexp_replace behavior in v8.3.4 ?  (Richard Huxton <dev@archonet.com>)
Re: maybe incorrect regexp_replace behavior in v8.3.4 ?  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-general

Hi:

 

bi_hsx_a0_latest=# select regexp_replace('xxx','^xxx$','abc');

regexp_replace

----------------

abc

(1 row)

expected behavior because there's a match

 

 

bi_hsx_a0_latest=# select regexp_replace('xxx','^xxxy$','abc');

regexp_replace

----------------

xxx

(1 row)

expected because there is no match (the 'y' in 'xxxy')

 

 

 

bi_hsx_a0_latest=# select regexp_replace('xxx','^xxxy$',null);

regexp_replace

----------------

 

(1 row)

But why did it return null in this case?  I would think no match would leave it 'xxx'.

 

Thanks in Advance for any help and/or explanation.

 

 

В списке pgsql-general по дате отправления:

Предыдущее
От: Vibhor Kumar
Дата:
Сообщение: Re: casting behavior of oids and relation names
Следующее
От: Richard Huxton
Дата:
Сообщение: Re: maybe incorrect regexp_replace behavior in v8.3.4 ?