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