Greg Stark <[EMAIL PROTECTED]> writes:I'm leaning towards suggesting that postgres should follow sql-99 here and normalize all array indexes to have a lower bound of 1.
That would break even more things, no?
On the other hand, it'd get rid of the problem that we presently face with dump/restore of arrays that don't have lower bound 1. Because pg_dump doesn't do anything to mark such values, they'll end up with lower bound 1 after reload anyway. The fact that we haven't heard lots of squawks about that suggests to me that not many people are using such arrays at present ...
The more I think about it, the more I like it. Does everyone else agree that a lower bound of 1 complies with the spec?
Joe
---------------------------(end of broadcast)--------------------------- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
