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.  (John R Pierce <pierce@hogranch.com>)
Список 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 по дате отправления:

Предыдущее
От: Stephane Bortzmeyer
Дата:
Сообщение: Re: Data types for IP address.
Следующее
От: Ioana Danes
Дата:
Сообщение: Re: Logged statement apparently did not commited...