Multi-dimensional arrays

"Raymond O'Donnell" <rod@xxxxxx> · Sat, 15 Mar 2014 12:51:41 +0000

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@xxxxxx

-- 
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general