Re: Index not being used in MAX function (7.2.3)

Поиск
Список
Период
Сортировка
От Jim C. Nasby
Тема Re: Index not being used in MAX function (7.2.3)
Дата
Msg-id 20030612220050.GR40542@flake.decibel.org
обсуждение исходный текст
Ответ на Re: Index not being used in MAX function (7.2.3)  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-general
On Wed, Jun 11, 2003 at 01:02:57PM -0400, Tom Lane wrote:
> "Jim C. Nasby" <jim@nasby.net> writes:
> > Not to drag this out further, but you might want to hold off on that
> > patch. 7.4 is supposed to use indexes for max/min.
>
> Where did you get that idea?

I remember seeing something about someone committing the min/max to
ORDER BY/LIMIT transform, but obviously I must have been smoking
something. My bad.
--
Jim C. Nasby (aka Decibel!)                    jim@nasby.net
Member: Triangle Fraternity, Sports Car Club of America
Give your computer some brain candy! www.distributed.net Team #1828

Windows: "Where do you want to go today?"
Linux: "Where do you want to go tomorrow?"
FreeBSD: "Are you guys coming, or what?"

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

Предыдущее
От: Stephan Szabo
Дата:
Сообщение: Re: Query planner question
Следующее
От: Roland Glenn McIntosh
Дата:
Сообщение: How can I insert a UTF-8 character with psql?