Search Postgresql Archives

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

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



On Mon, Oct 24, 2005 at 16:21:57 -0700,
  felix@xxxxxxxxxxx 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.

---------------------------(end of broadcast)---------------------------
TIP 4: Have you searched our list archives?

               http://archives.postgresql.org

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux