Re: Comments on Exclusion Constraints and related datatypes - Mailing list pgsql-hackers

From Kevin Grittner
Subject Re: Comments on Exclusion Constraints and related datatypes
Date
Msg-id 4BA74E20020000250003005A@gw.wicourts.gov
Whole thread Raw
In response to Re: Comments on Exclusion Constraints and related datatypes  (Simon Riggs <simon@2ndQuadrant.com>)
List pgsql-hackers
Simon Riggs <simon@2ndQuadrant.com> wrote:
> Yes, for most people touching != overlap. So it just looks like a
> bug.
A quick search of the web turned up a definition of overlap in
geometry as meaning that two polygons share at least one *internal*
point, which would be consistent with your interpretation; but there
is the issue of breaking existing code.  Perhaps people are now
accustomed to following the existing overlaps test with a test that
the area of intersection is non-zero?
Anyway, based on what I found, we should document the current
behavior, as the term in PostgreSQL doesn't seem to match the
conventional definition in geometry.
-Kevin


pgsql-hackers by date:

Previous
From: David Fetter
Date:
Subject: Re: Comments on Exclusion Constraints and related datatypes
Next
From: Andrew Dunstan
Date:
Subject: Re: Comments on Exclusion Constraints and related datatypes