Re: Single-argument variant for array_length and friends? - Mailing list pgsql-hackers

From Pavel Stehule
Subject Re: Single-argument variant for array_length and friends?
Date
Msg-id CAFj8pRAsM2+yPLLk5gmHpTrjVT9-Qr+Ht6ou-CnaJiP=BQHWaA@mail.gmail.com
Whole thread Raw
In response to Re: Single-argument variant for array_length and friends?  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: Single-argument variant for array_length and friends?  (Brendan Jurd <direvus@gmail.com>)
List pgsql-hackers
2013/3/21 Tom Lane <tgl@sss.pgh.pa.us>:
> Brendan Jurd <direvus@gmail.com> writes:
>> While I was working on my empty array patch I was frequently irritated
>> by the absence of an array_length(anyarray).  The same goes for
>> array_upper and array_lower.  Most of the time when I work with
>> arrays, they are 1-D, and it's inelegant to having to specify which
>> dimension I mean when there is only one to choose from.
>
>> The question I have (and would appreciate your input on) is how such
>> single-argument variants should behave when operating on an array with
>> multiple dimensions?
>
> I'm not entirely convinced that this is a good idea, but if we're going
> to allow it I would argue that "array_length(a)" should be defined as
> "array_length(a, 1)".  The other possibilities are too complicated to
> explain in as few words.
>

exactly

+1

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: Craig Ringer
Date:
Subject: Re: Trust intermediate CA for client certificates
Next
From: Brendan Jurd
Date:
Subject: Re: Single-argument variant for array_length and friends?