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
r...@iol.ie


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

Reply via email to