Hi to all!
Is it possible to define indexes on a column with BIGINT datatype? See
this example:
testdb=# create table a (col1 integer not null primary key);
NOTICE: CREATE TABLE/PRIMARY KEY will create implicit index 'a_pkey' for
table 'a'
CREATE
testdb=# create table b (col1 bigint
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
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