max | last INET in table - Mailing list pgsql-general

From Roderick A. Anderson
Subject max | last INET in table
Date
Msg-id Pine.LNX.4.33.0209111400530.21275-100000@main.cyber-office.net
Whole thread Raw
List pgsql-general
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?


TIA,
Rod
--
  "Open Source Software - Sometimes you get more than you paid for..."


pgsql-general by date:

Previous
From: Ewald Geschwinde
Date:
Subject: Re: XML and PostgreSQL
Next
From: "Ligia Pimentel"
Date:
Subject: Re: Table with 90 columns