Re: Best way to index IP data? - Mailing list pgsql-performance

From Steve Atkins
Subject Re: Best way to index IP data?
Date
Msg-id 1259C7B1-C948-4326-B827-849C64B61A16@blighty.com
Whole thread Raw
In response to Re: Best way to index IP data?  (Andrew Sullivan <ajs@crankycanuck.ca>)
Responses Re: Best way to index IP data?
Re: Best way to index IP data?
List pgsql-performance
On Jan 11, 2008, at 2:24 PM, Andrew Sullivan wrote:

> On Fri, Jan 11, 2008 at 05:02:36PM -0500, Michael Stone wrote:
>
>> networks), but there's a conspicuous lack of a type for (hosts). I
>> suppose if you really are sure that you want to store hosts and not
>> networks
>
> Well, part of the trouble is that in the CIDR world, an IP without a
> netmask
> can be dangerously ambiguous.  I can see why the design is as it is
> for that
> reason.  (But I understand the problem.)

I don't think there's ambiguity about what an dotted-quad without a
netmask
means, and hasn't been for a long time. Am I missing something?

There is ambiguity when you feed non dotted-quads into the
existing cidr I/O functions[1], but that's both a dead horse,
and not something likely to actually affect users negatively.

Cheers,
   Steve

[1] Because postgresql copied obsolete pre-CIDR code from libbind.

pgsql-performance by date:

Previous
From: Andrew Sullivan
Date:
Subject: Re: Best way to index IP data?
Next
From: Pomarede Nicolas
Date:
Subject: Re: Best way to index IP data?