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

Поиск
Список
Период
Сортировка
От Bruno Wolff III
Тема Re: Generic Q about max(id) vs ORDER BY ID DESC LIMIT 1 -- SOLVED
Дата
Msg-id 20051026172219.GA11447@wolff.to
обсуждение исходный текст
Ответ на Re: Generic Q about max(id) vs ORDER BY ID DESC LIMIT 1 -- SOLVED  (felix@crowfix.com)
Список 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 по дате отправления:

Предыдущее
От: "Joshua D. Drake"
Дата:
Сообщение: Re: Why database is corrupted after re-booting
Следующее
От: "Joshua D. Drake"
Дата:
Сообщение: Re: Why database is corrupted after re-booting