number of elements in a multidimensional array

From: "SunWuKung" <Balazs(dot)Klein(at)t-online(dot)hu>
To: pgsql-general(at)postgresql(dot)org
Subject: number of elements in a multidimensional array
Date: 2006-08-31 15:17:35
Message-ID: 1157037455.753385.91450@p79g2000cwp.googlegroups.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

>From this array how could I get back the fact that this array consists
of a two dimensional array with X elements?

Select array_dims('{{1,4,10,11},{1,5,4,5}}'::text [])

I would like to get back the number 4 here?

Thanks for the help.
Balázs

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Joshua D. Drake 2006-08-31 15:18:59 Re: Fatal error while installing
Previous Message Greg Sabino Mullane 2006-08-31 15:02:49 Re: Cutting the Gborg throat