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

From Bruce Momjian
Subject Re: Comments on Exclusion Constraints and related datatypes
Date
Msg-id 201006030147.o531lhD13152@momjian.us
Whole thread Raw
In response to Re: Comments on Exclusion Constraints and related datatypes  (Robert Haas <robertmhaas@gmail.com>)
List pgsql-hackers
Robert Haas wrote:
> > * inet datatypes don't have a commutative operator on which a unique
> > index can be built. There is no "overlaps" equivalent, which again is a
> > shame because that stops them being used with the new feature.
> 
> This would be a nice thing to fix, and I was thinking about doing it,
> but I just ran out of time.  I think it can be left for 9.1.  I have
> not infrequently wanted to build an IP allocation database, and this
> would be perfect for that.

Added to TODO:
Add INET overlaps operator, for use by exclusion constraints    *
http://archives.postgresql.org/pgsql-hackers/2010-03/msg00845.php
 

--  Bruce Momjian  <bruce@momjian.us>        http://momjian.us EnterpriseDB
http://enterprisedb.com
 + None of us is going to be here forever. +


pgsql-hackers by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: Comments on Exclusion Constraints and related datatypes
Next
From: Florian Pflug
Date:
Subject: Re: recovery getting interrupted is not so unusual as it used to be