Re: Is upper_inc ever true for dateranges?

Поиск
Список
Период
Сортировка
От Ken Tanzer
Тема Re: Is upper_inc ever true for dateranges?
Дата
Msg-id CAD3a31VOmB15sgvDQ2f2A9t5zs55riowu9iokzkajQvxMFHXpQ@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Is upper_inc ever true for dateranges?  ("David G. Johnston" <david.g.johnston@gmail.com>)
Список pgsql-general
On Tue, Jul 28, 2020 at 2:24 PM David G. Johnston <david.g.johnston@gmail.com> wrote:
On Tue, Jul 28, 2020 at 2:19 PM Ken Tanzer <ken.tanzer@gmail.com> wrote:
So here's my question.  Will the upper_inc function always return false for a non-null daterange?  And if so, what's the point of the function?  And/or is it different for other kinds of ranges?

Ranges over discrete types are always canonicalized while ranges over non-discrete types (i.e., float) cannot.


Oh that makes perfect sense.  Thank you!

Ken

 
David J.




--
AGENCY Software  
A Free Software data system
By and for non-profits
(253) 245-3801

learn more about AGENCY or
follow the discussion.

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

Предыдущее
От: "David G. Johnston"
Дата:
Сообщение: Re: Is upper_inc ever true for dateranges?
Следующее
От: Andres Freund
Дата:
Сообщение: Re: bad JIT decision