Re: Some questions about the array.

Поиск
Список
Период
Сортировка
От Teodor Sigaev
Тема Re: Some questions about the array.
Дата
Msg-id 565D92F7.5000505@sigaev.ru
обсуждение исходный текст
Ответ на Re: Some questions about the array.  (YUriy Zhuravlev <u.zhuravlev@postgrespro.ru>)
Ответы Re: Some questions about the array.  (YUriy Zhuravlev <u.zhuravlev@postgrespro.ru>)
Список pgsql-hackers
> 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@sigaev.ru
  WWW: http://www.sigaev.ru/
 



В списке pgsql-hackers по дате отправления:

Предыдущее
От: Amit Kapila
Дата:
Сообщение: Re: parallel joins, and better parallel explain
Следующее
От: YUriy Zhuravlev
Дата:
Сообщение: Re: Some questions about the array.