I heard back from Paul Vixie and he says that it should be possible to
store two values in a unique index if they differ only in netbits.  I
am sending a patch in.

-- 
D'Arcy J.M. Cain <darcy@{druid|vex}.net>   |  Democracy is three wolves
http://www.druid.net/darcy/                |  and a sheep voting on
+1 416 424 2871     (DoD#0082)    (eNTP)   |  what's for dinner.

Tue, 1 Jun 1999 21:30:16 -0400 (EDT)
"D'Arcy" "J.M." Cain <darcy@druid.net>
INET and CIDR comparisons
At 09:30 PM 6/1/99 -0400, D'Arcy" "J.M." Cain wrote:
>I heard back from Paul Vixie and he says that it should be possible to
>store two values in a unique index if they differ only in netbits.  I
>am sending a patch in.

I've stayed out of this discussion, but Paul makes a lot of
sense.  They're NOT the same networks...



- Don Baccus, Portland OR <dhogaza@pacifier.com>
  Nature photos, on-line guides, and other goodies at
  http://donb.photo.net

Tue, 01 Jun 1999 19:40:36 -0700
Don Baccus <dhogaza@pacifier.com>
Re: [HACKERS] INET and CIDR comparisons
On Tue, 1 Jun 1999, D'Arcy J.M. Cain wrote:

> I heard back from Paul Vixie and he says that it should be possible to
> store two values in a unique index if they differ only in netbits. 

This is definitely true.  E.g., we have an in-house database which records
internet address delegations wherein a.b.c.0/22 can be and often is the
parent of a.b.c.0/23.  They should definitely be recignized as unique
from each other.

> I am sending a patch in.

Groovy.  I'll be pestering the present developer of that database to
uniquify the index.  8^)

--
Todd Graham Lewis                        Postmaster, MindSpring Enterprises
tlewis@mindspring.net                                (800) 719-4664, x22804

"A pint of sweat will save a gallon of blood."          -- George S. Patton


Tue, 1 Jun 1999 22:56:59 -0400 (EDT)
Todd Graham Lewis <tlewis@mindspring.net>
Re: [HACKERS] INET and CIDR comparisons
> I heard back from Paul Vixie and he says that it should be possible to
> store two values in a unique index if they differ only in netbits.  I
> am sending a patch in.

Thanks.  One more item I can remove from Open Items list.

-- 
  Bruce Momjian                        |  http://www.op.net/~candle
  maillist@candle.pha.pa.us            |  (610) 853-3000
  +  If your life is a hard drive,     |  830 Blythe Avenue
  +  Christ can be your backup.        |  Drexel Hill, Pennsylvania 19026

Tue, 1 Jun 1999 23:34:59 -0400 (EDT)
Bruce Momjian <maillist@candle.pha.pa.us>
Re: [HACKERS] INET and CIDR comparisons
Thus spake Don Baccus
> At 09:30 PM 6/1/99 -0400, D'Arcy" "J.M." Cain wrote:
> >I heard back from Paul Vixie and he says that it should be possible to
> >store two values in a unique index if they differ only in netbits.  I
> >am sending a patch in.
> 
> I've stayed out of this discussion, but Paul makes a lot of
> sense.  They're NOT the same networks...

Agreed.  My only point was that using the fields was probably a bad
idea anyway and, if you did, allowing both then made even less sense
but that's more of design issue.

In any case, if someone wants the protection, they can always add a unique
index on host(field).

-- 
D'Arcy J.M. Cain <darcy@{druid|vex}.net>   |  Democracy is three wolves
http://www.druid.net/darcy/                |  and a sheep voting on
+1 416 424 2871     (DoD#0082)    (eNTP)   |  what's for dinner.

Wed, 2 Jun 1999 18:18:33 -0400 (EDT)
"D'Arcy" "J.M." Cain <darcy@druid.net>
Re: [HACKERS] INET and CIDR comparisons