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
> <http://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