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

From Sim Zacks
Subject Re: Data types for IP address.
Date
Msg-id 4D64FDDA.1040603@compulab.co.il
Whole thread Raw
In response to Data types for IP address.  (Gaini Rajeshwar <raja.rajeshwar2006@gmail.com>)
Responses Re: Data types for IP address.  (Stephane Bortzmeyer <bortzmeyer@nic.fr>)
List pgsql-general

a regular varchar or text field.


On 02/23/2011 02:09 PM, Gaini Rajeshwar wrote:

Hi All,

I wanted to store ip addresses in table. I wanted to support the following 3 types of ip addresses.

1. Wildcard format     :     1.2.3.*

2. CIDR format            :     1.2.3/24  OR  1.2.3.4/255.255.255.0

3. Start-End IP format :      1.2.3.0-1.2.3.255


I had a look at CIDR datatype and inet datatype but it seems they support only partial of the above requirements. Any suggestions on what datatype is useful for this purpose?

Thanks

pgsql-general by date:

Previous
From: Gaini Rajeshwar
Date:
Subject: Data types for IP address.
Next
From: Stephane Bortzmeyer
Date:
Subject: Re: Data types for IP address.