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 20030611155920.GM40542@flake.decibel.org
обсуждение исходный текст
Ответ на Re: Index not being used in MAX function (7.2.3)  (Paulo Jan <admin@digital.ddnet.es>)
Ответы 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 02:21:00PM +0200, Paulo Jan wrote:
>     It's a btree, but anyway, I see that others have already answered my
> question. So it's a "feature" and not a bug? Hrmpf.
>     (BTW, the code I was running wasn't written by me; it was part of
> Phorum, a PHP web posting board application. I'll try to patch it to
> make it use "SELECT id... ORDER BY id DESC LIMIT 1" and see how it goes).

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.
--
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 по дате отправления:

Предыдущее
От: "Jim C. Nasby"
Дата:
Сообщение: Re: [HACKERS] SAP and MySQL ... [and Benchmark]
Следующее
От: Erik Price
Дата:
Сообщение: pg_dump -> \i infile