Re: Should array_length() Return NULL - Mailing list pgsql-hackers

From Pavel Stehule
Subject Re: Should array_length() Return NULL
Date
Msg-id CAFj8pRA7odP+1BwKOQR7P8gRzepuZBO_1jrCTarRA3W0nrzxvA@mail.gmail.com
Whole thread Raw
In response to Re: Should array_length() Return NULL  (Tom Lane <tgl@sss.pgh.pa.us>)
List 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 by date:

Previous
From: Michael Paquier
Date:
Subject: Re: Support for REINDEX CONCURRENTLY
Next
From: Brendan Jurd
Date:
Subject: Re: Should array_length() Return NULL