Re: Array types

On Wed, Apr 8, 2009 at 11:35 AM, Greg Stark <stark(at)enterprisedb(dot)com> wrote:
> On Wed, Apr 8, 2009 at 4:11 PM, John Lister
> <john(dot)lister-ps(at)kickstone(dot)com> wrote:
>> Cheers for the pointers. Am i right in thinking that if i get an array of
>> arrays, the nested arrays are sent in wire format as well - it seems to be
>> from the docs.
>
> No, you can't easily get an array of arrays in Postgres. You can get
> multi-dimensional arrays but that's one big array with multiple
> dimensions.  The text output form does look like an array of arrays
> but they don't behave like you might think they would:

one note about that: you can have array of composites with arrays in
them, so you can get arbitrary levels of nesting.

merlin