Re: Array behavior oddities - Mailing list pgsql-hackers

From Tom Lane
Subject Re: Array behavior oddities
Date
Msg-id 13177.1200372622@sss.pgh.pa.us
Whole thread Raw
In response to Array behavior oddities  (Bruce Momjian <bruce@momjian.us>)
Responses Re: Array behavior oddities
Re: Array behavior oddities
List pgsql-hackers
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


pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: SSL over Unix-domain sockets
Next
From: Markus Schiltknecht
Date:
Subject: Re: Declarative partitioning grammar