Re: Index not being used in MAX function (7.2.3) - Mailing list pgsql-general

From Paulo Jan
Subject Re: Index not being used in MAX function (7.2.3)
Date
Msg-id 3EE71EAC.1060505@digital.ddnet.es
Whole thread Raw
In response to Re: Index not being used in MAX function (7.2.3)  (Jonathan Bartlett <johnnyb@eskimo.com>)
Responses 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>)
List 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 by date:

Previous
From: "Bruno BAGUETTE"
Date:
Subject: RE : PostgreSQL coredump : Couldn't find any tables, sequences or indices!
Next
From: Karsten Hilbert
Date:
Subject: doing VALID UNTIL programmatically in SQL ?