Re: Range Types: << >> -|- ops vs empty range
От
Kevin Grittner
Тема
Re: Range Types: << >> -|- ops vs empty range
Дата
Msg-id
4D552191020000250003A85F@gw.wicourts.gov
Ответ на
Re: Range Types: << >> -|- ops vs empty range (Jeff Davis)
Список
Дерево обсуждения
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 по дате отправления