Content-Type: text/plain;
  charset="iso-8859-1"
From: "D'Arcy J.M. Cain" <darcy@druid.net>
To: Michael Meskes <meskes@postgresql.org>,
	Rob Fowler <postgres@mianos.com>
Subject: Re: embedded sql interface to ip address type
Date: Sat, 22 Mar 2003 05:33:30 -0500
User-Agent: KMail/1.4.3
Cc: pgsql-interfaces@postgresql.org
References: <20030321064112.GA5117@firewall.keta.mine.nu>
	<20030321150648.GB27690@feivel.fam-meskes.de>
In-Reply-To: <20030321150648.GB27690@feivel.fam-meskes.de>
MIME-Version: 1.0
Message-Id: <200303220533.30512.darcy@druid.net>
Content-Transfer-Encoding: quoted-printable

> What exactly do you mean?  A C type for IP addresses? That doesn't
> exist. Right now this type has to be stored in character strings.

You mean base types written in C?  We certainly do.

darcy=3D# select '123.4.5.6'::inet << '123.4.5.0/24'::cidr;
 ?column?
----------
 t
(1 row)

darcy=3D# select '123.4.5.6'::inet << '123.4.6.0/24'::cidr;
 ?column?
----------
 f
(1 row)

The above says that the IP address 123.4.5.6 is in the CIDR block 123.4.5.0=
/24=20
but not in 123.4.6.0/24.

We also have a MAC address type. See the documentation pages at=20
http://www.postgresql.org/docs/view.php?version=3D7.3&idoc=3D0&file=3Ddatat=
ype-net-types.html=20
and=20=20
http://www.postgresql.org/docs/view.php?version=3D7.3&idoc=3D0&file=3Dfunct=
ions-net.html=20
for details.

--=20
D'Arcy J.M. Cain <darcy@{druid|vex}.net>   |  Democracy is three wolves
http://www.druid.net/darcy/                |  and a sheep voting on
+1 416 425 1212     (DoD#0082)    (eNTP)   |  what's for dinner.