In article <cabrt9rar2bfrxdx93h_aeqskmuchmwursfenp8itspexsws...@mail.gmail.com>, Marti Raudsepp <ma...@juffo.org> writes:
> Hi, > On Tue, Jul 5, 2011 at 09:50, Yan Cheng CHEOK <ycch...@yahoo.com> wrote: >> The essential difference between inet and cidr data types is that inet >> accepts values with nonzero bits to the right of the 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? -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
