Horton
Menu

Re: 7.1.2 vs. INT8 indexes

Tom Lane <tgl@sss.pgh.pa.us>

View thread
From: Tom Lane <tgl@sss.pgh.pa.us>
To: Michael Graff <explorer@flame.org>
Cc: pgsql-general@postgresql.org
Date: 2001-06-06T14:53:26Z
Lists: pgsql-general 
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