Re: Indexed access for INET/ CIDR datatype - Mailing list pgsql-novice

From Bruno Wolff III
Subject Re: Indexed access for INET/ CIDR datatype
Date
Msg-id 20030619184942.GA15093@wolff.to
Whole thread Raw
In response to Indexed access for INET/ CIDR datatype  ("Kaitharam, Ananth" <AKaitharam@gomez.com>)
List pgsql-novice
On Thu, Jun 19, 2003 at 14:27:46 -0400,
  "Kaitharam, Ananth" <AKaitharam@gomez.com> wrote:
>
> I was hoping that, by using the INET datatype, I could do lookups of
> individual IPs against a range efficiently, but that doesn't seem to be the
> case.

This just came up today in another thread and the answer is that if you
use a btree index a range scan over the index will be used.

pgsql-novice by date:

Previous
From: Tom Lane
Date:
Subject: Re: Indexed access for INET/ CIDR datatype
Next
From: Lynna Landstreet
Date:
Subject: Re: "Bad date external representation"