Re: Data types for IP address.

From: Michael Glaesemann <grzm(at)seespotcode(dot)net>
To: John R Pierce <pierce(at)hogranch(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Data types for IP address.
Date: 2011-02-23 19:40:22
Message-ID: B36FDF94-A327-4F66-80D9-FA49E46C8E0A@seespotcode.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Alvaro Herrera 2011-02-23 19:48:22 Re: How to extract a value from a record using attnum or attname?
Previous Message Kevin Grittner 2011-02-23 19:20:16 Re: How to extract a value from a record using attnum or attname?