Re: Range Types - typo + NULL string constructor

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Range Types - typo + NULL string constructor
Дата
Msg-id 13601.1318355506@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: Range Types - typo + NULL string constructor  (Jeff Davis <pgsql@j-davis.com>)
Список pgsql-hackers
Jeff Davis <pgsql@j-davis.com> writes:
> Tom made an observation about '[1,INT_MAX]' thowing an error because
> canonicalization would try to increment INT_MAX. But I'm not
> particularly disturbed by it. If you want a bigger range, use int8range
> or numrange -- the same advice we give to people who want unsigned
> types. Or, for people who really need the entire range of signed int4
> exactly, they can easily make their own range type that canonicalizes to
> '[]'.

I agree we shouldn't contort the entire design to avoid that corner
case.  We should, however, make sure that the increment *does* throw
an error, and not just silently overflow.
        regards, tom lane


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

Предыдущее
От: Jeff Davis
Дата:
Сообщение: Re: Range Types - typo + NULL string constructor
Следующее
От: David Fetter
Дата:
Сообщение: Re: Range Types - typo + NULL string constructor