Re: 7.1.2 vs. INT8 indexes

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Michael Graff <explorer(at)flame(dot)org>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: 7.1.2 vs. INT8 indexes
Date: 2001-06-06 14:53:26
Message-ID: 23860.991839206@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Michael Graff <explorer(at)flame(dot)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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Mathieu Arnold 2001-06-06 15:05:13 Re: pg_dump problem
Previous Message Andrew Gould 2001-06-06 14:49:27 Re: pg_dump problem