7.1.2 vs. INT8 indexes - Mailing list pgsql-general

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

When I use INT, it uses the index.

Is there some trick to make this work, or am I just screwed?

Thanks :)

--Michael

pgsql-general by date:

Previous
From: "Frank"
Date:
Subject: about PostgreSQL...(important)
Next
From: "J"
Date:
Subject: Using imbedded SQL, how do I connect tp Postgresql on a remote host?