Re: Data types for IP address.

Sim Zacks <sim@xxxxxxxxxxxxxx> · Wed, 23 Feb 2011 14:30:18 +0200



    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