Denis Gasparin <[EMAIL PROTECTED]> writes:
> On table a (INTEGER datatype) the search is done using the index.
> Instead on table b (BIGINT datatype) the search is always done using the
> seq scan.
Try
select * from b where col1 = 123::int8;
The query planner is not presently very smart
I search in the archive and i have found that i have to specify the type of
the column at the end of the query... so the new query is :
explain select * from b where col1=123::int8;
In this way, the explain output is correct.
The e-mail i found in the archive says that the problem will be solv
