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

Поиск
Список
Период
Сортировка
От Paulo Jan
Тема Re: Index not being used in MAX function (7.2.3)
Дата
Msg-id 3EE71EAC.1060505@digital.ddnet.es
обсуждение исходный текст
Ответ на Re: Index not being used in MAX function (7.2.3)  (Jonathan Bartlett <johnnyb@eskimo.com>)
Ответы doing VALID UNTIL programmatically in SQL ?
Re: Index not being used in MAX function (7.2.3)
Re: Index not being used in MAX function (7.2.3)
Список pgsql-general
Jonathan Bartlett wrote:
> Is your index a hash or btree?
>
> Jon
>


    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).



                    Paulo Jan.
                    DDnet.



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