Re: Generic Q about max(id) vs ORDER BY ID DESC LIMIT 1 -- SOLVED

From: Bruno Wolff III <bruno(at)wolff(dot)to>
To: felix(at)crowfix(dot)com
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Generic Q about max(id) vs ORDER BY ID DESC LIMIT 1 -- SOLVED
Date: 2005-10-26 17:22:19
Message-ID: 20051026172219.GA11447@wolff.to
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Mon, Oct 24, 2005 at 16:21:57 -0700,
felix(at)crowfix(dot)com wrote:
> On Mon, Oct 24, 2005 at 07:14:43PM -0400, Alex Turner wrote:
> > I believe based on semi-recent posts that MIN and MAX are now treated
> > as special cases in 8.1, and are synonymous with select id order by id
> > desc limit 1 etc..
>
> Aha! I looked it up in the release notes, you are right. I had never
> thought they would not be special cased.

They really aren't being special cased in 8.1. There is a new way of handling
them in a general way to could be used by other functions with similar
properties.

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Troy 2005-10-26 17:38:27 Re: Why database is corrupted after re-booting
Previous Message Joshua D. Drake 2005-10-26 17:10:10 Re: Why database is corrupted after re-booting