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 20030619170044.GA14063@wolff.to
Whole thread Raw
In response to Indexed access for INET/ CIDR datatype  ("Kaitharam, Ananth" <AKaitharam@gomez.com>)
Responses Re: Indexed access for INET/ CIDR datatype
List pgsql-novice
On Tue, Jun 17, 2003 at 08:25:04 -0400,
  "Kaitharam, Ananth" <AKaitharam@gomez.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.

pgsql-novice by date:

Previous
From: Douglas Trainor
Date:
Subject: Re: Documentation Tools
Next
From: "Knut P. Lehre"
Date:
Subject: returning recordsets/cursors in plpgsql 7.2.1