Re: data type for storing IP address?

From: Gus Spier <gus.spier_at_gmail.com>
Date: Tue, 1 Apr 2008 15:20:01 -0400
Message-ID: <6d3967610804011220q233d8a2auf99a4c39e303d53e@mail.gmail.com>


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_at_proquest.com> 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_at_proquest.com
> www.proquest.com
> www.csa.com
>
> ProQuest...Start here.
>
>
> -----Original Message-----
> From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org]
> On Behalf Of Vordos, Suzy
> Sent: Tuesday, April 01, 2008 2:07 PM
> To: oracle-l_at_freelists.org
> 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.
> --
> http://www.freelists.org/webpage/oracle-l
>
>
> --
> http://www.freelists.org/webpage/oracle-l
>
>
>

--
http://www.freelists.org/webpage/oracle-l
Received on Tue Apr 01 2008 - 14:20:01 CDT

Original text of this message