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 ?  (Karsten Hilbert <Karsten.Hilbert@gmx.net>)
Re: Index not being used in MAX function (7.2.3)  (Chris Gamache <cgg007@yahoo.com>)
Re: Index not being used in MAX function (7.2.3)  ("Jim C. Nasby" <jim@nasby.net>)
Список 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 по дате отправления:

Предыдущее
От: "Bruno BAGUETTE"
Дата:
Сообщение: RE : PostgreSQL coredump : Couldn't find any tables, sequences or indices!
Следующее
От: Karsten Hilbert
Дата:
Сообщение: doing VALID UNTIL programmatically in SQL ?