>> Multidim arrays are why we can't have nice things.
>
> Yeah, I think that was not our best moment. :-(
They were one of those hacks which looked really clever at the time, but
proved not to be so. Unfortunately, they *are* useful, and are being
used; I use MD arrays all the time to push data in and out of PL/R., and
now that we have a JSON type I'm using them to generate arrays-of-arrays
using JSON conversion functions. I'm sure many others are doing the
same, so there's no killing the feature.
Actually, if you think about it, we've never had "arrays" in PostgreSQL
... we have always had matrixes. If you think about things that way,
most of the current functionality makes sense.
--
Josh Berkus
PostgreSQL Experts Inc.
http://pgexperts.com