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
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? |