Re: Array behavior oddities

Bruce Momjian <bruce@momjian.us> writes:
>   If any dimension is written as a slice, i.e. contains a colon, then all
>   dimensions are treated as slices.

> Is the the behavior of assuming an entry with no colon is a slice what
> we want, or are we just stuck with it?

Why do you find that surprising?  It's either a slice or it isn't,
there's no halfway point.  Are you proposing to throw an error if only
some of the subscripts have colons?  What would be the point?

> Is there a reason out-of-bounds array accesses behave differently for
> slices and non-slices?

History (although "sloppy original implementation" would do too).  I'm
not sure if we should try to clean it up --- there've not been that many
complaints, but I'm sure we'd get complaints from people whose code
stopped working, if we change it.
        regards, tom lane