Re: Range Types: << >> -|- ops vs empty range
От
Andrew Dunstan
Тема
Re: Range Types: << >> -|- ops vs empty range
Дата
Msg-id
4D55778B.70801@dunslane.net
Ответ на
Re: Range Types: << >> -|- ops vs empty range (Robert Haas)
Список
Дерево обсуждения
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>
On 02/11/2011 12:36 PM, Robert Haas wrote: > On Fri, Feb 11, 2011 at 12:26 PM, Jeff Davis wrote: >> On Fri, 2011-02-11 at 12:03 -0500, Robert Haas wrote: >>> For what it's worth, my completely uninformed opinion is that >>> comparison operators shouldn't error out. I haven't read the patch so >>> I'm not sure what those operators are defined to do, though. >> ">>" 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. > Hmm, so an empty range is a range that includes nothing at all, right? > Not "everything in the world"? > > Are we sure we even want to have that concept? I have no particular opinion on that, but if we do then ISTM all the above (and particularly the last) should return false if either operand is an empty range. cheers andrew
В списке pgsql-hackers по дате отправления
От: Stephen Frost
Дата:
