Postgres Pro
Downloads
Home   >   mailing lists

Re: 7.1.2 vs. INT8 indexes - Mailing list pgsql-general

From Tom Lane
Subject Re: 7.1.2 vs. INT8 indexes
Date
Msg-id 23860.991839206@sss.pgh.pa.us
Whole thread Raw
In response to 7.1.2 vs. INT8 indexes  (Michael Graff <explorer@flame.org>)
List pgsql-general
Tree view 
Michael Graff <explorer@flame.org> writes:
> When I create a table with an INT8 member and create an index on it,
> a sequential scan is performed on select.

Cast the constant to int8 explicitly.

            regards, tom lane

pgsql-general by date:

Previous
From: Denis Gasparin
Date:
Subject: Re: Re: Pgsql vs Interbase: Transaction benchmark
Next
From: Tom Lane
Date:
Subject: Re: pg_dump problem