Re: Some questions about the array.

> On Friday 27 November 2015 17:23:35 Teodor Sigaev wrote:
>> 1
>> Documentation isn't very informative
> Added example with different results.
Perfect

>> 2
>> Seems, error messages are too inconsistent. If you forbid omitting bound in
>> assigment then if all cases error message should be the same or close.
> Done. Skipping lower boundary is no longer an error.
>
> Thank you for your review.

Much better, but:

# create table xxx (a int[]);
# update xxx set a[2:] = '{1,2}';
UPDATE 0
# insert into xxx values ('{1,2,3,3,4,4,5}');
INSERT 0 1
# update xxx set a[2:] = '{1,2}';
ERROR: cannot determine upper index for empty array

As I understand, update should fail with any array, so, first update should fail
too. Am I right?

--
Teodor Sigaev E-mail: teodor(at)sigaev(dot)ru
WWW: http://www.sigaev.ru/