Re: Should array_length() Return NULL

Поиск
Список
Период
Сортировка
От Pavel Stehule
Тема Re: Should array_length() Return NULL
Дата
Msg-id CAFj8pRA7odP+1BwKOQR7P8gRzepuZBO_1jrCTarRA3W0nrzxvA@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Should array_length() Return NULL  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-hackers
2013/3/16 Tom Lane <tgl@sss.pgh.pa.us>:
> Brendan Jurd <direvus@gmail.com> writes:
>> On 16 March 2013 09:07, 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.
>
>> I'm going to ask the question that immediately comes to mind: Is there
>> anything good at all about being able to define a zero-dimensional
>> array?
>
> Perhaps not.  I think for most uses, a 1-D zero-length array would be
> just as good.  I guess what I'd want to know is whether we also need
> to support higher-dimensional zero-size arrays, and if so, what does
> the I/O syntax for those look like?
>
> Another fly in the ointment is that if we do redefine '{}' as meaning
> something other than a zero-D array, how will we handle existing
> database entries that are zero-D arrays?
>

a issue with zero dimension array is long story and I'' be really
happy when this story finish

Has somebody any useful example with zero dimensional array ?? Use
other programming languages zero dim array ??

Regards

Pavel

>                         regards, tom lane
>
>
> --
> Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-hackers



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

Предыдущее
От: Michael Paquier
Дата:
Сообщение: Re: Support for REINDEX CONCURRENTLY
Следующее
От: Brendan Jurd
Дата:
Сообщение: Re: Should array_length() Return NULL