Re: array_length(anyarray) - Mailing list pgsql-hackers

From Florian Pflug
Subject Re: array_length(anyarray)
Date
Msg-id 646139A2-20F7-4F32-AACB-20CCEE1D135B@phlo.org
Whole thread Raw
In response to Re: array_length(anyarray)  (Merlin Moncure <mmoncure@gmail.com>)
List pgsql-hackers
On Jan10, 2014, at 15:10 , Merlin Moncure <mmoncure@gmail.com> wrote:
> On Fri, Jan 10, 2014 at 6:00 AM, Florian Pflug <fgp@phlo.org> wrote:
>> On Jan10, 2014, at 11:00 , Merlin Moncure <mmoncure@gmail.com> wrote:
>>> On Fri, Jan 10, 2014 at 3:52 AM, Marko Tiikkaja <marko@joh.to> wrote:
>>>> On 1/10/14, 10:41 AM, Merlin Moncure wrote:
>>>>>
>>>>> What's needed for better iteration support (IMO)
>>>>> is a function that does what unnest does but returns an array on
>>>>> indexes (one per dimsension) -- a generalization of the
>>>>> _pg_expandarray function.  Lets' say 'unnest_dims'.
>>>>
>>>>
>>>> So  unnest_dims('{{1,2},{3,4}}'::int[])  would return  VALUES (1,
>>>> '{1,2}'::int[]), (2, '{3,4}'::int[])?  If so, then yes, that's a
>>>> functionality I've considered us to have been missing for a long time.
>>>
>>> not quite.  it returns int[], anyelement: so, using your example, you'd get:
>>>
>>> [1,1], 1
>>> [1,2], 2
>>> [2,1], 3
>>> [2,2], 4
>>
>> Now that we have WITH ORDINALITY, it'd be sufficient to have a
>> variant of array_dims() that returns int[][] instead of text, say
>> array_dimsarray(). Your unnest_dims could then be written as
>>
>>  unnest(array_dimsarray(array)) with ordinality
>
> hm, not quite following that.  maybe an example?
>
> my issue with 'WITH ORDINALITY' (while it's pretty neat) is that it
> doesn't give you the dimension coordinate of each datum so you can't
> really use it to slice.  with unnest_dims(), you an slice, say via:

Sorry, I misunderstood what you were proposing. I though you intended
unnest_dims to returns one row per dimension, containing the index and
bounds of that dimension. And yeah, that fact your your mail showed
unnest_dims returning *4* rows for a *2*-dimensional array should have
tipped me off.

best regards,
Florian Pflug




pgsql-hackers by date:

Previous
From: Simon Riggs
Date:
Subject: Re: Simple improvements to freespace allocation
Next
From: Tom Lane
Date:
Subject: Re: Compiling extensions on Windows