Re: what is good solution for support NULL inside string_to_array function?

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: what is good solution for support NULL inside string_to_array function?
Дата
Msg-id 292.1272941676@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: what is good solution for support NULL inside string_to_array function?  (Josh Berkus <josh@agliodbs.com>)
Ответы Re: what is good solution for support NULL inside string_to_array function?  (Andrew Dunstan <andrew@dunslane.net>)
Re: what is good solution for support NULL inside string_to_array function?  (Pavel Stehule <pavel.stehule@gmail.com>)
Re: what is good solution for support NULL inside string_to_array function?  (Steve Crawford <scrawford@pinpointresearch.com>)
Список pgsql-hackers
Josh Berkus <josh@agliodbs.com> writes:
>> quietly removing NULL is maybe good for compatibility but is wrong for
>> functionality. 

> I agree.  I wasn't aware of this little misfeature.

> Default display for NULL should be a zero-length string.

That's just as broken as Pavel's suggestion.  Unless you have something
that is guaranteed distingishable from the output of any non-null value,
you really can't make a significant improvement here.
        regards, tom lane


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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: COPY is not working
Следующее
От: Andrew Dunstan
Дата:
Сообщение: Re: what is good solution for support NULL inside string_to_array function?