Re: Getting row with id=max(id)

Поиск
Список
Период
Сортировка
От Alex Pilosov
Тема Re: Getting row with id=max(id)
Дата
Msg-id Pine.BSO.4.10.10106071550070.5424-100000@spider.pilosoft.com
обсуждение исходный текст
Ответ на Re: Getting row with id=max(id)  (Gerald Gutierrez <gml1@coldresist.com>)
Список pgsql-sql
On Thu, 7 Jun 2001, Gerald Gutierrez wrote:

> Perhaps if the server internally rewrote the second query into the first, 
> it would make the intuitive version much faster. The same can be done for 
> min() and perhaps other functions as well.

Unfortunately, currently that's not possible, because of the design of
aggregate functions (they are pluggable, and the API for aggregate
functions has no support for understanding that an index may be used to
compute an aggregate). It'd be nice for a TODO item...:

-alex



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

Предыдущее
От: Gerald Gutierrez
Дата:
Сообщение: Re: Getting row with id=max(id)
Следующее
От: Dennis
Дата:
Сообщение: Forein Key Problem