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

From: felix(at)crowfix(dot)com
To: pgsql-general(at)postgresql(dot)org
Subject: Re: Generic Q about max(id) vs ORDER BY ID DESC LIMIT 1 -- SOLVED
Date: 2005-10-24 23:21:57
Message-ID: 20051024232157.GA12734@crowfix.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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.

Thanks.

--
... _._. ._ ._. . _._. ._. ___ .__ ._. . .__. ._ .. ._.
Felix Finch: scarecrow repairman & rocket surgeon / felix(at)crowfix(dot)com
GPG = E987 4493 C860 246C 3B1E 6477 7838 76E9 182E 8151 ITAR license #4933
I've found a solution to Fermat's Last Theorem but I see I've run out of room o

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Michael Fuhr 2005-10-24 23:29:31 Re: Generic Q about max(id) vs ORDER BY ID DESC LIMIT 1
Previous Message Alex Turner 2005-10-24 23:14:43 Re: Generic Q about max(id) vs ORDER BY ID DESC LIMIT 1