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

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: IP address, subnet query behaves wrong for /32
Дата
Msg-id 16388.1438888231@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: IP address, subnet query behaves wrong for /32  ("David G. Johnston" <david.g.johnston@gmail.com>)
Ответы Re: IP address, subnet query behaves wrong for /32  ("Richard RK. Klingler" <richard@klingler.net>)
Список pgsql-sql
"David G. Johnston" <david.g.johnston@gmail.com> writes:
> On Thu, Aug 6, 2015 at 10:02 AM, Adrian Klaver <adrian.klaver@aklaver.com>
> wrote:
>> " 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.

No, only one.  There is no difference between '192.168.0.1'::inet and
'192.168.0.1/32'::inet; they're the same value.  The first notation
is merely a shorthand for the second.
        regards, tom lane



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

Предыдущее
От: "David G. Johnston"
Дата:
Сообщение: Re: IP address, subnet query behaves wrong for /32
Следующее
От: "Richard RK. Klingler"
Дата:
Сообщение: Re: IP address, subnet query behaves wrong for /32