Re: Data types for IP address.
От | Stephane Bortzmeyer |
---|---|
Тема | Re: Data types for IP address. |
Дата | |
Msg-id | 20110223124421.GB5208@nic.fr обсуждение исходный текст |
Ответ на | Data types for IP address. (Gaini Rajeshwar <raja.rajeshwar2006@gmail.com>) |
Ответы |
Re: Data types for IP address.
|
Список | pgsql-general |
On Wed, Feb 23, 2011 at 05:39:26PM +0530, Gaini Rajeshwar <raja.rajeshwar2006@gmail.com> wrote a message of 52 lines which said: > 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 What is the difference between 1.2.3.* and 1.2.3.0/24? For me, it is exactly the same. If you just want the ability to INPUT 1.2.3.*, just write a small conversion routine in your favorite programming language. > *3. Start-End IP format :* 1.2.3.0-1.2.3.255 You don't even need to program the conversion, it is already done: % netmask 1.2.3.0:1.2.3.255 1.2.3.0/24
В списке pgsql-general по дате отправления: