Re: Data types for IP address.

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