exclusion constraint for ranges of IP - Mailing list pgsql-sql

From Herouth Maoz
Subject exclusion constraint for ranges of IP
Date
Msg-id CAF36091-203E-4C10-AA53-7D9087114D35@unicell.co.il
Whole thread Raw
Responses Re: exclusion constraint for ranges of IP  (Herouth Maoz <herouth@unicell.co.il>)
List pgsql-sql
Hi,

I'm designing a new database. One of the table contains allowed IP ranges for a customer (Fields: customer_id, from_ip,
to_ip)which is intended to check - if  an incoming connection's originating IP number falls within the range, it is
identifiedas a particular customer. 

Naturally, I'd like to have constraints on the table that prevent entering of ip ranges that overlap. Is there a way to
dothat with exclusion constraints? Or do I have to define a new type for this? 

Herouth

pgsql-sql by date:

Previous
From: Mik Rose
Date:
Subject: Re: (pgsql8.4) DATA Corruption
Next
From: Harald Fuchs
Date:
Subject: Re: exclusion constraint for ranges of IP