Re: seqscan instead of index scan - Mailing 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;