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

From Roderick A. Anderson
Subject Re: max | last INET in table
Date
Msg-id Pine.LNX.4.33.0209120843280.32058-100000@main.cyber-office.net
Whole thread Raw
In response to max | last INET in table  ("Roderick A. Anderson" <raanders@acm.org>)
List 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..."


pgsql-general by date:

Previous
From: "scott.marlowe"
Date:
Subject: Re: Postgres hardware configuration, clustering and
Next
From: Tim Perdue
Date:
Subject: Latitude / Longitude