BIGINT datatype and Indexes Failure

From: Denis Gasparin <denis(at)edinet(dot)it>
To: pgsql-general(at)postgresql(dot)org
Subject: BIGINT datatype and Indexes Failure
Date: 2001-08-24 12:57:57
Message-ID: 5.1.0.14.0.20010824145244.00aa9740@10.1.1.2
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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 not null primary key);
NOTICE: CREATE TABLE/PRIMARY KEY will create implicit index 'b_pkey' for
table 'b'
CREATE
testdb=# explain select * from a where col1=123;
NOTICE: QUERY PLAN:

Index Scan using a_pkey on a (cost=0.00..8.14 rows=10 width=4)

EXPLAIN
testdb=# explain select * from b where col1=123;
NOTICE: QUERY PLAN:

Seq Scan on b (cost=0.00..22.50 rows=10 width=8)

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.

Is it a bug?

I use Postgresql 7.1.2 on RedHat 7.1. All the regress tests has been
completed correctely during installation.

Please, let me know as soon as possible...

Regards,

Eng. Denis Gasparin: denis(at)edistar(dot)com
---------------------------
Programmer & System Administrator - Edistar srl

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2001-08-24 13:13:25 Re: problems transfering databases
Previous Message Oliver Elphick 2001-08-24 12:48:22 Re: valid NULL DATE value