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: "'pgsql-novice(at)postgresql(dot)org'" <pgsql-novice(at)postgresql(dot)org>
Subject: Re: Indexed access for INET/ CIDR datatype
Date: 2003-06-19 17:00:44
Message-ID: 20030619170044.GA14063@wolff.to
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

On Tue, Jun 17, 2003 at 08:25:04 -0400,
"Kaitharam, Ananth" <AKaitharam(at)gomez(dot)com> wrote:
> Is there a way to index the >>= or <<= operators for CIDR/ INET datatypes? I
> built a btree index, which works for the = clause, but not the others.

I don't think so. Those operators aren't total orders and I think btree
will only work with total orders. I expect that it should be possible
to develop rtree or gist indexes though.

In response to

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Tom Lane 2003-06-19 17:57:57 Re: Indexed access for INET/ CIDR datatype
Previous Message Ennio-Sr 2003-06-19 15:04:16 Re: Multibyte support and accented characters