Re: Multi-dimensional arrays

On 15/03/2014 14:01, Thom Brown wrote:
> On 15 March 2014 12:51, Raymond O'Donnell <rod(at)iol(dot)ie> wrote:
>> Hello all,
>>
>> Here's an odd one (to me anyway) which I ran into today.... if I have a
>> multidimensional array, why does the following return NULL?
>>
>> select (array[['abc','def'], ['ghi','jkl']])[1]
>>
>> I would have expected it to return {abc, def}. This, however, returns
>> 'abc' as expected:
>>
>> select (array[['abc','def'], ['ghi','jkl']])[1][1]
>
> Hmm... I'm not sure. You can get to it with slices for some reason:
>
> # select (array[['abc','def'], ['ghi','jkl']])[0:1];
> array
> -------------
> {{abc,def}}
> (1 row)

True... though that gives you a 2D array, whereas I was hoping for a 1D
array from (array[...])[1]. I should have mentioned my version, by the way:

select version();

PostgreSQL 9.3.0, compiled by Visual C++ build 1600, 64-bit

Ray.

--
Raymond O'Donnell :: Galway :: Ireland
rod(at)iol(dot)ie