Re: Inconsistent behavior on Array & Is Null?

Tom Lane wrote:
> Greg Stark <gsstark(at)mit(dot)edu> 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