Re: Should array_length() Return NULL

Поиск
Список
Период
Сортировка
От David E. Wheeler
Тема Re: Should array_length() Return NULL
Дата
Msg-id E65FC6AF-0A6E-40E3-B4C9-56E9599A6577@justatheory.com
обсуждение исходный текст
Ответ на Re: Should array_length() Return NULL  (Tom Lane <tgl@sss.pgh.pa.us>)
Ответы Re: Should array_length() Return NULL  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-hackers
On Mar 15, 2013, at 3:07 PM, Tom Lane <tgl@sss.pgh.pa.us> wrote:

> The thing is that that syntax creates an array of zero dimensions,
> not one that has 1 dimension and zero elements.  So "0" would be
> incorrect.
> 
> Our handling of empty arrays leaves something to be desired, I agree,
> but making it more consistent seems like a large task.  Hacking
> array_length in isolation will certainly not help.

Oh. Is there a way to declare an empty 1-dimension array?

Thanks,

David




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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: Should array_length() Return NULL
Следующее
От: Tom Lane
Дата:
Сообщение: Re: Materialized view assertion failure in HEAD