BUG #4007: chr(0) doesn't work anymore

Поиск
Список
Период
Сортировка
От Steve Clark
Тема BUG #4007: chr(0) doesn't work anymore
Дата
Msg-id 200803031528.m23FS4G9040185@wwwmaster.postgresql.org
обсуждение исходный текст
Ответы Re: BUG #4007: chr(0) doesn't work anymore  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-bugs
The following bug has been logged online:

Bug reference:      4007
Logged by:          Steve Clark
Email address:      sclark@netwolves.com
PostgreSQL version: 8.3.0
Operating system:   FreeBSD 6.2
Description:        chr(0) doesn't work anymore
Details:

Until 8.3.0 the following worked:
SELECT coalesce(param_value,chr(0)) from t_system_params where  param_name =
'default_unit_key';

it now fails with:
ERROR:  null character not permitted

The documentation says:
For other multibyte encodings the argument must designate a strictly ASCII
character.

NUL = 0 is a valid ascii character.

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

Предыдущее
От: Steve Clark
Дата:
Сообщение: Re: ecpg produces code that won't compile
Следующее
От: Tom Lane
Дата:
Сообщение: Re: BUG #4007: chr(0) doesn't work anymore