Re: max | last INET in table

From: "Roderick A(dot) Anderson" <raanders(at)acm(dot)org>
To: <pgsql-general(at)postgresql(dot)org>
Subject: Re: max | last INET in table
Date: 2002-09-12 15:45:02
Message-ID: Pine.LNX.4.33.0209120843280.32058-100000@main.cyber-office.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Thu, 12 Sep 2002, Peter Gibbs wrote:

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

Geez I knew there was away. In fact I think I've got an old message with
a similar situation that uses this.

> 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.

Good point.

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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message grant.johnson 2002-09-12 16:44:29 Faster not in
Previous Message scott.marlowe 2002-09-12 15:26:15 Re: Postgres hardware configuration, clustering and