Re: Difference between inet and cidr - Mailing list pgsql-general

From Harald Fuchs
Subject Re: Difference between inet and cidr
Date
Msg-id 861uy4etug.fsf@mgm.protecting.net
Whole thread Raw
In response to Difference between inet and cidr  (Yan Cheng CHEOK <yccheok@yahoo.com>)
List 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 by date:

Previous
From: Marti Raudsepp
Date:
Subject: Re: Difference between inet and cidr
Next
From: Geoffrey Myers
Date:
Subject: Re: out of memory error