Multi-dimensional arrays - Mailing list pgsql-general

From Raymond O'Donnell
Subject Multi-dimensional arrays
Date
Msg-id 53244CDD.9070208@iol.ie
Whole thread Raw
Responses Re: Multi-dimensional arrays  (Thom Brown <thom@linux.com>)
List pgsql-general
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]

Thanks,

Ray.

--
Raymond O'Donnell :: Galway :: Ireland
rod@iol.ie


pgsql-general by date:

Previous
From: "Yngve N. Pettersen"
Date:
Subject: Re: Possible multiprocess lock/unlock-loop problem in Postgresql 9.2
Next
From: "Yngve N. Pettersen"
Date:
Subject: Re: Possible multiprocess lock/unlock-loop problem in Postgresql 9.2