On Wed, Apr 8, 2009 at 11:35 AM, Greg Stark <st...@enterprisedb.com> wrote: > On Wed, Apr 8, 2009 at 4:11 PM, John Lister > <john.lister...@kickstone.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 -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers