Re: Ranges for well-ordered types

Поиск
Список
Период
Сортировка
От Bruno Wolff III
Тема Re: Ranges for well-ordered types
Дата
Msg-id 20060613042556.GA26794@wolff.to
обсуждение исходный текст
Ответ на Re: Ranges for well-ordered types  (Michael Glaesemann <grzm@seespotcode.net>)
Список pgsql-hackers
On Sun, Jun 11, 2006 at 15:13:39 +0900, Michael Glaesemann <grzm@seespotcode.net> wrote:
> 
> That's different from being able to show equivalence between two  
> ranges in different representations, e.g., r1 = r2 iff a1 = a2 and b1  
> = next(b2). As Bruno pointed out earlier, in some cases, a closed- 
> open representation is desirable, and I think that in others, such as  
> date ranges, a closed-closed representation is useful. Another place  
> where I'd use a closed-closed representation would be for describing  
> score ranges for grades (e.g., 70-79 is a C, 80-89 is a B). I'm not  
> sure how to go about converting between these two representations  
> without using a successor (or predecessor) function.

Date ranges are really closed open as well (as finite sets of isolated points
are both open and closed). The only oddity would be that the date used to
indicate the open end of the range might not be what the user expects.


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

Предыдущее
От: Bruce Momjian
Дата:
Сообщение: Re: CSV mode option for pg_dump
Следующее
От: "Dave Page"
Дата:
Сообщение: Re: pg_get_INDEXdef - opclass