Re: left and overleft/notright revisited: why !>> and !<< might be poor names - Mailing list pgsql-general

From Tom Lane
Subject Re: left and overleft/notright revisited: why !>> and !<< might be poor names
Date
Msg-id 16258.1081204794@sss.pgh.pa.us
Whole thread Raw
In response to left and overleft/notright revisited: why !>> and !<< might be poor names  (William White <bwhite@frognet.net>)
List pgsql-general
William White <bwhite@frognet.net> writes:
> Consider the empty interval (n,n) (any empty interval will do, they're
> all the same empty set),

I don't think that's the case.  [0,0) and [1,1) are certainly
distinguishable given the normal machine representation of intervals.
If you use a mathematical model that says they're not distinguishable,
that says to me that you chose the wrong model --- especially when the
model leads you into logical difficulties that need not (and do not)
exist in the actual implementation.

My feeling about it is [0,0) << [1,1) but not vice versa.

            regards, tom lane

pgsql-general by date:

Previous
From: Joe Conway
Date:
Subject: Re: Cursors and Transactions, why?
Next
From: Lamar Owen
Date:
Subject: Re: RPM init-script: Why the locale setting?