> I expect to lose this argument, but I think this is a terrible idea.
> Users really hate it when they try to upgrade and find that they, uh,
> can't, because of some application-level incompatibility like this.
> They hate it twice as much when the change is essentially cosmetic.
> There's no functional problems with arrays as they exist today that
> this change would solve.
Sure there is. How do you distinguish between an array which is NULL
and an array which is empty?
Also, the whole array_dims is NULL thing trips up pretty much every
single PG user who uses arrays for the first time. I'd expect when we
announce the fix, we'll find that many users where doing the wrong thing
in the first place and didn't know why it wasn't working.
--
Josh Berkus
PostgreSQL Experts Inc.
http://pgexperts.com