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. Regards, Marti -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
