From: | Steve Atkins <steve(at)blighty(dot)com> |
---|---|
To: | PostgreSQL Performance <pgsql-performance(at)postgresql(dot)org> |
Subject: | Re: Best way to index IP data? |
Date: | 2008-01-11 22:38:27 |
Message-ID: | 1259C7B1-C948-4326-B827-849C64B61A16@blighty.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | 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.
From | Date | Subject | |
---|---|---|---|
Next Message | Pomarede Nicolas | 2008-01-11 22:43:58 | Re: Best way to index IP data? |
Previous Message | Andrew Sullivan | 2008-01-11 22:24:03 | Re: Best way to index IP data? |