agora inbox for pgsql-sql@postgresql.org
help / color / mirror / Atom feedFrom: Richard RK. Klingler <richard@klingler.net>
To: pgsql-sql@postgresql.org <pgsql-sql@postgresql.org>
Subject: Re: IP address, subnet query behaves wrong for /32
Date: Thu, 6 Aug 2015 19:35:19 +0000
Message-ID: <10B2FB45-DFE8-4075-BFB0-36023ADF9837@klingler.net> (raw)
In-Reply-To: <16388.1438888231@sss.pgh.pa.us>
References: <1FC8E571-8456-4085-B59B-016ECD365768@klingler.net>
<55C39320.4010905@aklaver.com>
<CAKFQuwaj9HFTAU-soNt3mn4rCTJ8FUgHtnTg+ZsV2oGmMT=n8w@mail.gmail.com>
<16388.1438888231@sss.pgh.pa.us>
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-sql>
Thanks to all for the clarifications...
I'm looking at this form an application perspective...
as this would greatly enhance an IPAM database web application.
Sad there is no direct IP address sorting function like in MySQL (o;
cheers from .ch
richard
Am [DATE] schrieb "pgsql-sql-owner@postgresql.org im Auftrag von Tom Lane" <[ADDRESS]>:
>"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
--
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: <10B2FB45-DFE8-4075-BFB0-36023ADF9837@klingler.net>
Permalink: ../10B2FB45-DFE8-4075-BFB0-36023ADF9837@klingler.net/
Also on: postgresql.org/message-id/10B2FB45-DFE8-4075-BFB0-36023ADF9837@klingler.net
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: richard@klingler.net
Subject: Re: IP address, subnet query behaves wrong for /32
In-Reply-To: <10B2FB45-DFE8-4075-BFB0-36023ADF9837@klingler.net>
* 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