Re: [pmacct-discussion] reloading config & accuracy

[Aaron Glenn]

On Fri, Sep 25, 2009 at 4:59 AM, Tony <td_mi...@yahoo.com> wrote:
>
> Is there a way to sort it properly by IP address (so that .2 comes after .1) 
> in either an SQL query or in an XLS sheet ?
>

I hesitate to be 'that guy' but, you should look at using PostgreSQL.
I don't know enough about MySQL to make any suggestions specific to
it.

template1=> SELECT addr FROM inetsort ORDER BY addr DESC;
     addr
---------------
 212.76.90.226
 12.76.90.226
 12.76.89.226
 12.76.88.226
 12.76.87.226
 12.75.87.226
 11.75.87.226
 10.75.87.226
 9.75.87.226
 9.75.87.225
 9.75.87.224
(11 rows)

template1=> SELECT addr FROM inetsort ORDER BY addr ASC;
     addr
---------------
 9.75.87.224
 9.75.87.225
 9.75.87.226
 10.75.87.226
 11.75.87.226
 12.75.87.226
 12.76.87.226
 12.76.88.226
 12.76.89.226
 12.76.90.226
 212.76.90.226
(11 rows)

template1=> \d inetsort
  Table "public.inetsort"
 Column | Type | Modifiers
--------+------+-----------
 addr   | inet |


(:

aaron.glenn

_______________________________________________
pmacct-discussion mailing list
http://www.pmacct.net/#mailinglists