Re: inet increment w/ int8

Поиск
Список
Период
Сортировка
Искать
От
Greg Stark
Тема
Re: inet increment w/ int8
Дата
Msg-id
87d5sqk9c1.fsf@stark.xeocode.com
Ответ на
Список
Дерево обсуждения
inet increment w/ int8 "Ilya A. Kovalenko" <shadow@oganer.net>
Re: inet increment w/ int8 "Ilya A. Kovalenko" <shadow@oganer.net>
Re: inet increment w/ int8 Bruce Momjian <pgman@candle.pha.pa.us>
Re: inet increment w/ int8 "Ilya A. Kovalenko" <shadow@oganer.net>
Re: inet increment w/ int8 Bruce Momjian <pgman@candle.pha.pa.us>
Re: inet increment w/ int8 Bruno Wolff III <bruno@wolff.to>
Re: inet increment w/ int8 Greg Stark <gsstark@mit.edu>
Re: inet increment w/ int8 Bruce Momjian <pgman@candle.pha.pa.us>
Re: inet increment w/ int8 "Ilya A. Kovalenko" <shadow@oganer.net>
Re: inet increment w/ int8 Greg Stark <gsstark@mit.edu>
Re: inet increment w/ int8 "Ilya A. Kovalenko" <shadow@oganer.net>
Re: inet increment w/ int8 Bruno Wolff III <bruno@wolff.to>
Re: inet increment w/ int8 Patrick Welche <prlw1@newn.cam.ac.uk>

Bruce Momjian  writes:

> am thinking we should support only inet + inet, like this:
> 
> 	SELECT '1.2.3.4'::inet + '0.0.1.2'::inet;

I don't think inet+inet makes any sense.

I think inet+int4 should work by adding to the host address and overflowing if
it exceeds the network mask.

Ie, 

10.0.0.0/24   + 1 = 10.0.0.1/24
10.0.0.255/24 + 1 => overflow

Or

10.1/16 + 1      = 10.1.0.1/16
10.1/16 + 16384  = 10.1.64.0/16
10.1/16 + 65536  => overflow



-- 
greg


В списке pgsql-hackers по дате отправления
От: Tom Lane
Дата:
Сообщение: Re: Problem with PITR recovery
От: Bruce Momjian
Дата:
Сообщение: Re: inet increment w/ int8
FAQ