agora inbox for pgsql-sql@postgresql.org
help / color / mirror / Atom feedFrom: ktm@rice.edu <ktm@rice.edu>
To: 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, 6 Aug 2015 14:45:32 -0500
Message-ID: <20150806194532.GL539@aart.rice.edu> (raw)
In-Reply-To: <10B2FB45-DFE8-4075-BFB0-36023ADF9837@klingler.net>
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>
<10B2FB45-DFE8-4075-BFB0-36023ADF9837@klingler.net>
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-sql>
On Thu, Aug 06, 2015 at 07:35:19PM +0000, Richard RK. Klingler wrote:
> 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
>
What about:
select * from table order by inet(IP-ADDRESS);
Seems pretty straight-forward. What does MySQL do?
Regards,
Ken
--
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: <20150806194532.GL539@aart.rice.edu>
Permalink: ../20150806194532.GL539@aart.rice.edu/
Also on: postgresql.org/message-id/20150806194532.GL539@aart.rice.edu
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: ktm@rice.edu, richard@klingler.net
Subject: Re: IP address, subnet query behaves wrong for /32
In-Reply-To: <20150806194532.GL539@aart.rice.edu>
* 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