Re: GiST support for inet datatypes
От | Stephen Frost |
---|---|
Тема | Re: GiST support for inet datatypes |
Дата | |
Msg-id | 20140408210453.GF2556@tamriel.snowman.net обсуждение исходный текст |
Ответ на | Re: GiST support for inet datatypes (Robert Haas <robertmhaas@gmail.com>) |
Список | 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 по дате отправления: