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

From Bruno Wolff III
Subject Re: Generic Q about max(id) vs ORDER BY ID DESC LIMIT 1 -- SOLVED
Date
Msg-id 20051026172219.GA11447@wolff.to
Whole thread Raw
In response to Re: Generic Q about max(id) vs ORDER BY ID DESC LIMIT 1 -- SOLVED  (felix@crowfix.com)
List pgsql-general
On Mon, Oct 24, 2005 at 16:21:57 -0700,
  felix@crowfix.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.

pgsql-general by date:

Previous
From: "Joshua D. Drake"
Date:
Subject: Re: Why database is corrupted after re-booting
Next
From: "Joshua D. Drake"
Date:
Subject: Re: Why database is corrupted after re-booting