Re: max | last INET in table

Roderick A. Anderson wrote:

> Well this will seem strange but I'm trying to figure out a way to select
> the last INET value in a table.  I found that max() isn't defined for
> inet and a max(text()) gives - obviously - an alphabetical max which is
> incorrect.
>
> Is there a function I've missed or a SQL trick to get the last IP address
> out of a table?

select <inet field> from <table> order by <inet field> desc limit 1;

This will also use an index on <inet field> if there is one, in which
case it would have been faster even if max() worked.

--
Peter Gibbs
EmKel Systems