Postgres Pro
Downloads
Home   >   mailing lists

Re: IP address, subnet query behaves wrong for /32 - Mailing list pgsql-sql

From David G. Johnston
Subject Re: IP address, subnet query behaves wrong for /32
Date
Msg-id CAKFQuwaj9HFTAU-soNt3mn4rCTJ8FUgHtnTg+ZsV2oGmMT=n8w@mail.gmail.com
Whole thread Raw
In response to Re: IP address, subnet query behaves wrong for /32  (Adrian Klaver <adrian.klaver@aklaver.com>)
Responses Re: IP address, subnet query behaves wrong for /32
List pgsql-sql
Tree view
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 by date:

Previous
From: Adrian Klaver
Date:
Subject: Re: IP address, subnet query behaves wrong for /32
Next
From: Tom Lane
Date:
Subject: Re: IP address, subnet query behaves wrong for /32