Re: Data types for IP address. - Mailing list pgsql-general

From Gaini Rajeshwar
Subject Re: Data types for IP address.
Date
Msg-id AANLkTimpU6X1x0Q6Se8wE5SMr=-nFRG4FKzyovNOEzBt@mail.gmail.com
Whole thread Raw
In response to Re: Data types for IP address.  (Michael Glaesemann <grzm@seespotcode.net>)
List pgsql-general


On Thu, Feb 24, 2011 at 1:10 AM, Michael Glaesemann <grzm@seespotcode.net> wrote:

On Feb 23, 2011, at 13:49, John R Pierce wrote:

> On 02/23/11 4:44 AM, Stephane Bortzmeyer wrote:
>>> *3. Start-End IP format :*      1.2.3.0-1.2.3.255
>> You don't even need to program the conversion, it is already done:
>>
>> % netmask 1.2.3.0:1.2.3.255
>>         1.2.3.0/24
>
> yes, but what about 10.1.2.57-10.1.2.123 ?    presumably valid in his range system, and certainly NOT a valid CIDR range.

If it hasn't been mentioned already, take a look at ip4r. <http://pgfoundry.org/projects/ip4r/>

I will look into it. May i know how to use this data type? It is not available with postgreSQL 8.4 right?
I guess i have to download and integrate into postgreSQL, any suggestions on how to do? 

Michael Glaesemann
grzm seespotcode net




--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

pgsql-general by date:

Previous
From: Gaini Rajeshwar
Date:
Subject: Re: Data types for IP address.
Next
From: salah jubeh
Date:
Subject: Re: schema Cleanning