Re: Range Types: << >> -|- ops vs empty range

Поиск
Список
Период
Сортировка
Искать
От
Kevin Grittner
Тема
Re: Range Types: << >> -|- ops vs empty range
Дата
Msg-id
4D552191020000250003A85F@gw.wicourts.gov
Ответ на
Список
Дерево обсуждения
Range Types Jeff Davis <pgsql@j-davis.com>
Re: Range Types Jeff Davis <pgsql@j-davis.com>
Re: Range Types: << >> -|- ops vs empty range "Erik Rijkers" <er@xs4all.nl>
Re: Range Types: << >> -|- ops vs empty range Jeff Davis <pgsql@j-davis.com>
Re: Range Types: << >> -|- ops vs empty range Robert Haas <robertmhaas@gmail.com>
Re: Range Types: << >> -|- ops vs empty range Jeff Davis <pgsql@j-davis.com>
Re: Range Types: << >> -|- ops vs empty range "Kevin Grittner" <Kevin.Grittner@wicourts.gov>
Re: Range Types: << >> -|- ops vs empty range Josh Berkus <josh@agliodbs.com>
Re: Range Types: << >> -|- ops vs empty range "Kevin Grittner" <Kevin.Grittner@wicourts.gov>
Re: Range Types: << >> -|- ops vs empty range "Erik Rijkers" <er@xs4all.nl>
Re: Range Types: << >> -|- ops vs empty range Robert Haas <robertmhaas@gmail.com>
Re: Range Types: << >> -|- ops vs empty range Andrew Dunstan <andrew@dunslane.net>
Re: Range Types: << >> -|- ops vs empty range Bruce Momjian <bruce@momjian.us>
Re: Range Types: << >> -|- ops vs empty range Jeff Davis <pgsql@j-davis.com>
Re: Range Types: << >> -|- ops vs empty range Christopher Browne <cbbrowne@gmail.com>
Re: Range Types (catversion.h) "Erik Rijkers" <er@xs4all.nl>
Re: Range Types (catversion.h) Jeff Davis <pgsql@j-davis.com>
Re: Range Types (catversion.h) Tom Lane <tgl@sss.pgh.pa.us>
Re: Range Types (catversion.h) Jeff Davis <pgsql@j-davis.com>
Re: Range Types (catversion.h) Peter Eisentraut <peter_e@gmx.net>
Re: Range Types (catversion.h) Heikki Linnakangas <heikki.linnakangas@enterprisedb.com>
Re: Range Types (catversion.h) Robert Haas <robertmhaas@gmail.com>
Re: Range Types Dimitri Fontaine <dimitri@2ndQuadrant.fr>
Re: Range Types Jeff Davis <pgsql@j-davis.com>
Re: Range Types Dimitri Fontaine <dimitri@2ndQuadrant.fr>
Re: Range Types Jeff Davis <pgsql@j-davis.com>
Re: Range Types Jeff Davis <pgsql@j-davis.com>
Re: REVIEW Range Types "Erik Rijkers" <er@xs4all.nl>
Re: REVIEW Range Types Jeff Davis <pgsql@j-davis.com>
Re: Range Types - cache lookup failed for function "Erik Rijkers" <er@xs4all.nl>
Re: Range Types - cache lookup failed for function Jeff Davis <pgsql@j-davis.com>
Jeff Davis  wrote:
> ">>" means "strictly right of"
> "<<" means "strictly left of"
> "-|-" means "adjacent" (touching but not overlapping)
> 
> I'm open to suggestion about how those behave with empty ranges.
OK, that still leaves a lot to the imagination, though.  To try to
clarify in *my* mind:
"empty range"
=============
Zero length? If so, is it fixed at some point, but empty?   '(x,x)'?   '[x,x)'?
Is it everything? '[-inf,+inf]'?
Is it really meaningfully distinct from NULL?
Where do you see it being useful?
-Kevin

В списке pgsql-hackers по дате отправления
От: Alex Hunsaker
Дата:
От: Greg Smith
Дата:
FAQ