Horton
Menu

Re: Comments on Exclusion Constraints and related datatypes

Bruce Momjian <bruce@momjian.us>

View thread
From: Bruce Momjian <bruce@momjian.us>
To: Robert Haas <robertmhaas@gmail.com>
Cc: Simon Riggs <simon@2ndquadrant.com>, pgsql-hackers@postgresql.org
Date: 2010-06-03T01:47:43Z
Lists: 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. +