[SQL] exclusion constraint for ranges of IP

2011-08-21 Thread Herouth Maoz
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 identified as a particular customer. Naturally, I'd l

Re: [SQL] exclusion constraint for ranges of IP

2011-08-21 Thread Harald Fuchs
In article , Herouth Maoz writes: > 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 identifie