Re: IP address, subnet query behaves wrong for /32

Поиск
Список
Период
Сортировка
От David G. Johnston
Тема Re: IP address, subnet query behaves wrong for /32
Дата
Msg-id CAKFQuwaj9HFTAU-soNt3mn4rCTJ8FUgHtnTg+ZsV2oGmMT=n8w@mail.gmail.com
обсуждение исходный текст
Ответ на Re: IP address, subnet query behaves wrong for /32  (Adrian Klaver <adrian.klaver@aklaver.com>)
Ответы Re: IP address, subnet query behaves wrong for /32  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-sql
On Thu, Aug 6, 2015 at 10:02 AM, Adrian Klaver <adrian.klaver@aklaver.com> wrote:
http://www.postgresql.org/docs/9.2/interactive/functions-net.html

"The operators <<, <<=, >>, and >>= test for subnet inclusion."

http://www.postgresql.org/docs/9.2/interactive/datatype-net-types.html#DATATYPE-INET

" If the netmask is 32 and the address is IPv4, then the value does not indicate a subnet, only a single host."

So it is behaving as documented.

This seems overly simplified given that "<<=" will indeed match two host specifications.

David J.

В списке pgsql-sql по дате отправления:

Предыдущее
От: Adrian Klaver
Дата:
Сообщение: Re: IP address, subnet query behaves wrong for /32
Следующее
От: Tom Lane
Дата:
Сообщение: Re: IP address, subnet query behaves wrong for /32