Re: Single-argument variant for array_length and friends?

From: Brendan Jurd <direvus(at)gmail(dot)com>
To: Pavel Stehule <pavel(dot)stehule(at)gmail(dot)com>
Cc: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, pgsql-hackers(at)postgresql(dot)org
Subject: Re: Single-argument variant for array_length and friends?
Date: 2013-03-21 06:51:34
Message-ID: CADxJZo05oNBr6ifEco9jCrWmhVsDX7G1TnQtvwLpasWnx3AJGg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On 21 March 2013 17:32, Pavel Stehule <pavel(dot)stehule(at)gmail(dot)com> wrote:
> If I though about it more, I like to more limit one parametric
> array_length function just for only 1D array. So it is your A use
> case. But I understand so this variant is not orthogonal. Hard to say,
> what is better.
>

Yes, for me (a) is running a very close 2nd place to (c). The
strength of (a) is it means we aren't making guesses about the user's
intention. When a user concocts an expression that is ambiguous, I
feel it is usually good to kick it back to them and ask them to be
more precise.

On the other hand, I find it very natural to interpret "what is the
length of my multidim array" to mean "what is the length of the
outermost dimension of my multidim array", because to me a multidim
array is just an array that contains more arrays.

Cheers,
BJ

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Pavel Stehule 2013-03-21 07:00:16 Re: Single-argument variant for array_length and friends?
Previous Message Pavel Stehule 2013-03-21 06:32:21 Re: Single-argument variant for array_length and friends?