Re: seqscan instead of index scan - Mailing list pgsql-performance

From Martin Sarsale
Subject Re: seqscan instead of index scan
Date
Msg-id 1093889849.1680.83.camel@kadaif
Whole thread Raw
In response to Re: seqscan instead of index scan  ("Merlin Moncure" <merlin.moncure@rcsonline.com>)
Responses Re: seqscan instead of index scan  (Stephan Szabo <sszabo@megazone.bigpanda.com>)
Re: seqscan instead of index scan  (Greg Stark <gsstark@mit.edu>)
List pgsql-performance
On Mon, 2004-08-30 at 15:06, Merlin Moncure wrote:
> create function is_somethingable (ctype, dtype) returns boolean as

Thanks, but I would prefer a simpler solution.

I would like to know why this uses a seqscan instead of an index scan:

create index t_idx on t((c+d));
select * from t where c+d > 0;



Attachment

pgsql-performance by date:

Previous
From: Martin Sarsale
Date:
Subject: Re: seqscan instead of index scan
Next
From: "Merlin Moncure"
Date:
Subject: Re: seqscan instead of index scan