Re: Difference between inet and cidr

Поиск
Список
Период
Сортировка
От Harald Fuchs
Тема Re: Difference between inet and cidr
Дата
Msg-id 861uy4etug.fsf@mgm.protecting.net
обсуждение исходный текст
Ответ на Difference between inet and cidr  (Yan Cheng CHEOK <yccheok@yahoo.com>)
Список pgsql-general
In article <CABRT9RAr2bFrxdx93H_aEQsKmuchMwurSfENP8itSpExsWsF7g@mail.gmail.com>,
Marti Raudsepp <marti@juffo.org> writes:

> Hi,
> On Tue, Jul 5, 2011 at 09:50, Yan Cheng CHEOK <yccheok@yahoo.com> wrote:
>> The essential difference between inet and cidr data types is that inet accepts values with nonzero bits to the right
ofthe netmask, whereas cidr does not. 

> Say, if you have a /8 netmask, the 'cidr' type requires that all the
> 24 rightmost bits are zero. inet does not have this requirement.

> E.g:
> db=# select '255.0.0.0/8'::cidr;
> 255.0.0.0/8

> db=# select '255.1.0.0/8'::cidr;
> ERROR:  invalid cidr value: "255.1.0.0/8"
> DETAIL:  Value has bits set to right of mask.

> And inet allows this:
> db=# select '255.1.0.0/8'::inet;
> 255.1.0.0/8

> Hope that helps.

Do the inet/cidr types have any advantage over the ip4r contrib module?

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

Предыдущее
От: Marti Raudsepp
Дата:
Сообщение: Re: Difference between inet and cidr
Следующее
От: Geoffrey Myers
Дата:
Сообщение: Re: out of memory error