Re: Some array semantics issues

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Some array semantics issues
Дата
Msg-id 336.1132255789@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: Some array semantics issues  (Greg Stark <gsstark@mit.edu>)
Ответы Re: Some array semantics issues  (Joe Conway <mail@joeconway.com>)
Список pgsql-hackers
Greg Stark <gsstark@mit.edu> writes:
> Tom Lane <tgl@sss.pgh.pa.us> writes:
>> I don't have a lot of use for arguments that go "we should remove any
>> functionality that's not in the spec" ... ISTM that variable lower
>> bounds are clearly useful for some applications, and even if they had
>> bugs in earlier releases that's not an argument for removing them.

> Normally I don't either. But it's not just functionality that's not in the
> spec. It's functionality that creates behaviour the spec specifies otherwise.

AFAICS the only cases that give rise to arrays with lower bounds other
than one are:* direct entry of a literal with explicit lower bound;* assignment to a subscript or slice below 1;*
array_prepend(and the N/N+1-dimension case of array_cat).
 

I don't think "it's not in the spec" is a reason for rejecting #1 or #2.
But I agree that there is a reasonable case for modifying array_prepend
and array_cat so that they won't generate non-spec lower bounds where
none existed before.

How about changing them so that the lower bound of the right-hand array
is preserved, rather than decreased by one?
        regards, tom lane


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

Предыдущее
От: Simon Riggs
Дата:
Сообщение: Improving count(*)
Следующее
От: Martijn van Oosterhout
Дата:
Сообщение: Re: Improving count(*)