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

From Michael Glaesemann
Subject Re: Data types for IP address.
Date
Msg-id B36FDF94-A327-4F66-80D9-FA49E46C8E0A@seespotcode.net
Whole thread Raw
In response to Re: Data types for IP address.  (John R Pierce <pierce@hogranch.com>)
Responses Re: Data types for IP address.  (Gaini Rajeshwar <raja.rajeshwar2006@gmail.com>)
List pgsql-general
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/>

Michael Glaesemann
grzm seespotcode net




pgsql-general by date:

Previous
From: John R Pierce
Date:
Subject: Re: Data types for IP address.
Next
From: Merlin Moncure
Date:
Subject: Re: Deadlock on the same select for update