| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | Brendan Jurd <direvus(at)gmail(dot)com> |
| Cc: | pgsql-hackers(at)postgresql(dot)org |
| Subject: | Re: Single-argument variant for array_length and friends? |
| Date: | 2013-03-21 04:01:18 |
| Message-ID: | 1401.1363838478@sss.pgh.pa.us |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
Brendan Jurd <direvus(at)gmail(dot)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.
regards, tom lane
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Craig Ringer | 2013-03-21 05:42:55 | Re: Trust intermediate CA for client certificates |
| Previous Message | Tom Lane | 2013-03-21 03:46:23 | Re: find libxml2 using pkg-config |