On the other hand, there's nothing to stop us from creating such a datatype ... If I can steal some hours from everybody else screaming to get things done, that might be fun to work on. r, Gus On Tue, Apr 1, 2008 at 2:20 PM, Bobak, Mark <Mark.Bobak@xxxxxxxxxxxx> wrote: > Nope. No such datatype exists. > > -Mark > > -- > Mark J. Bobak > Senior Database Administrator, System & Product Technologies > ProQuest > 789 E. Eisenhower, Parkway, P.O. Box 1346 > Ann Arbor MI 48106-1346 > +1.734.997.4059 or +1.800.521.0600 x 4059 > mark.bobak@xxxxxxxxxxxx > www.proquest.com > www.csa.com > > ProQuest...Start here. > > > -----Original Message----- > From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] > On Behalf Of Vordos, Suzy > Sent: Tuesday, April 01, 2008 2:07 PM > To: oracle-l@xxxxxxxxxxxxx > Subject: data type for storing IP address? > > > Hello, > > PostgreSQL offers data types for storing IPv4, IPv6, and MAC network > addresses. Does Oracle yet have a similar data type that understands IP > addresses (and/or IP address ranges such as "192.168.0.0/16") so that > greater-than, less-than, between, and other comparisons can be made? > > Thanks, > Suzy > > > This communication is the property of Qwest and may contain confidential > or > privileged information. Unauthorized use of this communication is strictly > prohibited and may be unlawful. If you have received this communication > in error, please immediately notify the sender by reply e-mail and destroy > all copies of the communication and any attachments. > -- > //www.freelists.org/webpage/oracle-l > > > -- > //www.freelists.org/webpage/oracle-l > > >