Re: Single-argument variant for array_length and friends?

From: Brendan Jurd <direvus(at)gmail(dot)com>
To: Merlin Moncure <mmoncure(at)gmail(dot)com>
Cc: Pavel Stehule <pavel(dot)stehule(at)gmail(dot)com>, 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-23 09:53:06
Message-ID: CADxJZo1X+GH5YE5RvmzrQQ7W=uDSg6iaLEpqr4DvUCtfWX6ZcA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On 22 March 2013 09:12, Merlin Moncure <mmoncure(at)gmail(dot)com> wrote:
> On Thu, Mar 21, 2013 at 2:00 AM, Pavel Stehule <pavel(dot)stehule(at)gmail(dot)com> wrote:
>> lot of postgresql functions calculate with all items in array without
>> respect to dimensions - like unnest.
>>
>> so concept "use outermost dim" is not in pg now, and should not be
>> introduced if it is possible. More it goes against a verbosity concept
>> introduced by ADA and reused in PL/SQL and PL/pgSQL.
>
> and pl/psm*

Yeah, okay. That argument works for me. Let's go for option (a),
only allow the user to omit the dimension argument if the array is
1-D.

We still have the issue that Tom isn't convinced that the feature is
worth pursuing -- Tom, would you please elaborate a little on what you
dislike about it? I don't see much of a downside (just 3 extra
pg_procs).

Cheers,
BJ

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Adriano Lange 2013-03-23 10:17:53 Re: SDP query optimizer
Previous Message Amit Kapila 2013-03-23 09:43:51 Re: Page replacement algorithm in buffer cache