agora inbox for pgsql-sql@postgresql.org  

help / color / mirror / Atom feed

From: Tom Lane <tgl@sss.pgh.pa.us>
To: David G. Johnston <david.g.johnston@gmail.com>
Cc: Adrian Klaver <adrian.klaver@aklaver.com>
Cc: Richard RK. Klingler <richard@klingler.net>
Cc: pgsql-sql@postgresql.org <pgsql-sql@postgresql.org>
Subject: Re: IP address, subnet query behaves wrong for /32
Date: Thu, 06 Aug 2015 15:10:31 -0400
Message-ID: <16388.1438888231@sss.pgh.pa.us> (raw)
In-Reply-To: <CAKFQuwaj9HFTAU-soNt3mn4rCTJ8FUgHtnTg+ZsV2oGmMT=n8w@mail.gmail.com>
References: <1FC8E571-8456-4085-B59B-016ECD365768@klingler.net>
	<55C39320.4010905@aklaver.com>
	<CAKFQuwaj9HFTAU-soNt3mn4rCTJ8FUgHtnTg+ZsV2oGmMT=n8w@mail.gmail.com>
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-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


-- 
Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-sql

view thread (9+ messages)  latest in thread

Message-ID: <16388.1438888231@sss.pgh.pa.us>
Permalink:  ../16388.1438888231@sss.pgh.pa.us/
Also on:    postgresql.org/message-id/16388.1438888231@sss.pgh.pa.us

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-sql@postgresql.org
  Cc: tgl@sss.pgh.pa.us, david.g.johnston@gmail.com, adrian.klaver@aklaver.com, richard@klingler.net
  Subject: Re: IP address, subnet query behaves wrong for /32
  In-Reply-To: <16388.1438888231@sss.pgh.pa.us>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox