Re: Select not using primary key index - Mailing list pgsql-general

Carl van Tast wrote:
> On Thu, 14 Mar 2002 00:07:54 -0300, Sergio Freue <sfreue@yahoo.com>
> wrote:
>
>>create table testBig (id1 smallint not null,id2 smallint not
>>null,primary key (id1, id2));
>>
>>Add about 1,500,000 records
>>[...]
>>select * from testBig where id1 = 1585 and id2 = 42;
>
>
> select *
> from testBig
> where id1 = 1585::smallint and id2 = 42::smallint;
>
> HTH,
>  Carl van Tast


THANKS!!! That did it!

Is there any configuration parameter I can alter to get the same result?

Sergio Freue