Re: Why so few built-in range types?

Поиск
Список
Период
Сортировка
От Stephen Frost
Тема Re: Why so few built-in range types?
Дата
Msg-id 20111130205829.GE24234@tamriel.snowman.net
обсуждение исходный текст
Ответ на Re: Why so few built-in range types?  (Robert Haas <robertmhaas@gmail.com>)
Ответы Re: Why so few built-in range types?  (Robert Haas <robertmhaas@gmail.com>)
Список pgsql-hackers
* Robert Haas (robertmhaas@gmail.com) wrote:
> A CIDR address defines a range all by itself, without packing any
> other type on top.  It just needs GIST support, and an indexable
> operator for "contains or is contained by"; then, you can define an
> exclusion constraint over a CIDR column to enforce a
> no-duplicate-or-overlapping-IP-ranges rule.  I started working on that
> at one point, but I didn't have as much enthusiasm as the task needed
> so I gave up before accomplishing anything particularly useful.

Erm, isn't there a contrib type that already does all that for you..?
ip4r or whatever?  Just saying, if you're looking for that capability..

I do think it'd be kind of interesting to offer both that and a
straight-up 'ip_address' type w/ range types..
Thanks,
    Stephen

В списке pgsql-hackers по дате отправления:

Предыдущее
От: Robert Haas
Дата:
Сообщение: Re: WIP: cross column stats revisited ...
Следующее
От: Robert Haas
Дата:
Сообщение: Re: Why so few built-in range types?