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