Re: GiST support for inet datatypes - Mailing list pgsql-hackers

From Stephen Frost
Subject Re: GiST support for inet datatypes
Date
Msg-id 20140408210453.GF2556@tamriel.snowman.net
Whole thread Raw
In response to Re: GiST support for inet datatypes  (Robert Haas <robertmhaas@gmail.com>)
List pgsql-hackers
* Robert Haas (robertmhaas@gmail.com) wrote:
> On Tue, Apr 8, 2014 at 3:51 PM, Tom Lane <tgl@sss.pgh.pa.us> wrote:
> > I wrote:
> >> [ inet-gist-v6.patch ]
> >
> > Committed with some additional documentation work.  Thanks for
> > submitting this!
>
> NICE.  I'd like to tell you how excited I am about this part:
>
> # It also handles a new network
> # operator inet && inet (overlaps, a/k/a "is supernet or subnet of"),
> # which is expected to be useful in exclusion constraints.
>
> ...but I can't, because my mouth is too full of drool.  Wouldn't you
> really want that more for cidr than for inet, though?

You realize ip4r has had all this and more for, like, forever, right?
It's also more efficient wrt storage and generally more 'sane' regarding
operators, etc..

Just thought I'd share..  If you have a use-case, ip4r is what
everyone's been using for quite some time.  Also, yes, it supports both
ipv4 and ipv6, despite the name.
Thanks,
    Stephen

pgsql-hackers by date:

Previous
From: Florian Pflug
Date:
Subject: Re: [PATCH] Negative Transition Aggregate Functions (WIP)
Next
From: Peter Geoghegan
Date:
Subject: Re: Call for GIST/GIN/SP-GIST opclass documentation