Re: Odd error message (" hash indexes do not support whole-index scans")

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Marinos Yannikos <mjy(at)geizhals(dot)at>
Cc: pgsql-sql(at)postgresql(dot)org
Subject: Re: Odd error message (" hash indexes do not support whole-index scans")
Date: 2005-04-20 16:02:34
Message-ID: 1559.1114012954@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

Marinos Yannikos <mjy(at)geizhals(dot)at> writes:
> Shouldn't PostgreSQL behave in a different way in this case? (e.g. just
> not use the index):

Good catch. But why are you using a hash index for this?

regards, tom lane

In response to

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Stéphane RIFF 2005-04-20 16:11:40 Query question
Previous Message Marinos Yannikos 2005-04-20 15:23:06 Odd error message (" hash indexes do not support whole-index scans")