Data types for IP address.

From: Gaini Rajeshwar <raja(dot)rajeshwar2006(at)gmail(dot)com>
To: "pgsql-general(at)postgresql(dot)org mailing list" <pgsql-general(at)postgresql(dot)org>
Subject: Data types for IP address.
Date: 2011-02-23 12:09:26
Message-ID: AANLkTinf0gAa0WNP2+CSLP+pvbtWVkthFYAoV1wBSLaf@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Sim Zacks 2011-02-23 12:30:18 Re: Data types for IP address.
Previous Message Raymond O'Donnell 2011-02-23 11:13:41 Re: [GENERAL] Re: [GENERAL] Re: [GENERAL] FATAL: no pg_hba.conf entry for host “::1***"