Re: indices and cidr/inet type

From: Richard Welty <rwelty(at)averillpark(dot)net>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: indices and cidr/inet type
Date: 2003-08-06 01:56:43
Message-ID: E19kDXf-0004Jj-Gf@skipper.averillpark.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Tue, 05 Aug 2003 18:46:47 -0400 Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:

> Richard Welty <rwelty(at)averillpark(dot)net> writes:
> > hmmm. where should i go looking for sample code implementing operator
> > classes as an example?
>
> contrib. Specifically, I'd suggest looking at contrib/seg, which
> defines a datatype for "interval on the real line" and builds a GIST
> opclass for it. This seems like it'd map very easily to CIDR subnets.

very good, thanks.

i'll go rooting about for documentation on how GIST works.

also, how does 7.4 handle comparison of v6 and v4 addresses? i should think
it should map the v4 addresses into the v6 space provided for v4 mapping,
but that's not the only thing that might have been done.

richard
--
Richard Welty rwelty(at)averillpark(dot)net
Averill Park Networking 518-573-7592
Java, PHP, PostgreSQL, Unix, Linux, IP Network Engineering, Security

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Yudha Setiawan 2003-08-06 02:08:25 Re: Dump Customizing
Previous Message Ron Johnson 2003-08-06 01:49:23 Re: How to do?