> We already have the ability to define lower bounds other than 1 on
> arrays, and it would be inconsistent to allow that for arrays with
> elements, but not for arrays without. I could imagine somebody
> wanting to create an empty zero-based array, and then iteratively
> append elements to it.
Hmmm. You know, I think that's why we originally had array_upper() on
an empty array return NULL, not 0.
--
Josh Berkus
PostgreSQL Experts Inc.
http://pgexperts.com