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

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

В списке pgsql-general по дате отправления:

Предыдущее
От: Alex Turner
Дата:
Сообщение: Re: Generic Q about max(id) vs ORDER BY ID DESC LIMIT 1
Следующее
От: Michael Fuhr
Дата:
Сообщение: Re: Generic Q about max(id) vs ORDER BY ID DESC LIMIT 1