Postgres Pro
Downloads
Home   >   mailing lists

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

From Gaini Rajeshwar
Subject Data types for IP address.
Date
Msg-id AANLkTinf0gAa0WNP2+CSLP+pvbtWVkthFYAoV1wBSLaf@mail.gmail.com
Whole thread Raw
Responses Re: Data types for IP address.
Re: Data types for IP address.
List pgsql-general
Tree view
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: Raymond O'Donnell
Date:
Subject: Re: [GENERAL] Re: [GENERAL] Re: [GENERAL] FATAL: no pg_hba.conf entry for host “::1***"
Next
From: Sim Zacks
Date:
Subject: Re: Data types for IP address.