exclusion constraint for ranges of IP

Поиск
Список
Период
Сортировка
От Herouth Maoz
Тема exclusion constraint for ranges of IP
Дата
Msg-id CAF36091-203E-4C10-AA53-7D9087114D35@unicell.co.il
обсуждение исходный текст
Ответы Re: exclusion constraint for ranges of IP  (Herouth Maoz <herouth@unicell.co.il>)
Список 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 по дате отправления:

Предыдущее
От: Mik Rose
Дата:
Сообщение: Re: (pgsql8.4) DATA Corruption
Следующее
От: Harald Fuchs
Дата:
Сообщение: Re: exclusion constraint for ranges of IP