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

From: Paulo Jan <admin(at)digital(dot)ddnet(dot)es>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: Index not being used in MAX function (7.2.3)
Date: 2003-06-11 12:21:00
Message-ID: 3EE71EAC.1060505@digital.ddnet.es
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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.

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Karsten Hilbert 2003-06-11 12:59:53 doing VALID UNTIL programmatically in SQL ?
Previous Message Bruno BAGUETTE 2003-06-11 12:16:55 RE : PostgreSQL coredump : Couldn't find any tables, sequences or indices!