Re: Indexed access for INET/ CIDR datatype

From: Bruno Wolff III <bruno(at)wolff(dot)to>
To: "Kaitharam, Ananth" <AKaitharam(at)gomez(dot)com>
Cc: 'Tom Lane' <tgl(at)sss(dot)pgh(dot)pa(dot)us>, "'pgsql-novice(at)postgresql(dot)org'" <pgsql-novice(at)postgresql(dot)org>
Subject: Re: Indexed access for INET/ CIDR datatype
Date: 2003-06-19 18:49:42
Message-ID: 20030619184942.GA15093@wolff.to
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

On Thu, Jun 19, 2003 at 14:27:46 -0400,
"Kaitharam, Ananth" <AKaitharam(at)gomez(dot)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.

In response to

Browse pgsql-novice by date

  From Date Subject
Next Message Lynna Landstreet 2003-06-19 19:03:41 Re: "Bad date external representation"
Previous Message Kaitharam, Ananth 2003-06-19 18:27:46 Re: Indexed access for INET/ CIDR datatype