Re: Unique Indexes across multiple columns

2002-06-10 Thread Gerald Clark
It looks to me like 'a' is '127-30-127-1' Notice the dashes. I don't believe you are splitting the IP address into 4 separate numbers. Chris Knipe wrote: >Hi again, > >Not to long ago, I had a query regarding the best way to store IP addresses >in a DB, and make sure that they are unique. > >I

Re: Unique Indexes across multiple columns

2002-06-08 Thread Fred van Engen
Hi Chris, On Sat, Jun 08, 2002 at 11:44:43AM +0200, Chris Knipe wrote: > Not to long ago, I had a query regarding the best way to store IP addresses > in a DB, and make sure that they are unique. > > It was pointed out to me that I could use four smallint columns instead of a > varchar to store

Re: Unique Indexes across multiple columns

2002-06-08 Thread Joseph Bueno
Chris Knipe wrote : > > Hi again, > > Not to long ago, I had a query regarding the best way to store IP addresses > in a DB, and make sure that they are unique. > > It was pointed out to me that I could use four smallint columns instead of a > varchar to store these numbers, and just implement