Search Postgresql Archives

Re: Data types for IP address.

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 





On Thu, Feb 24, 2011 at 1:10 AM, Michael Glaesemann <grzm@xxxxxxxxxxxxxxx> 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@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux