Postgres Pro
Downloads
Home   >   mailing lists

Re: Bug #441: Index using INT8 data type is ignored - Mailing list pgsql-bugs

From Tom Lane
Subject Re: Bug #441: Index using INT8 data type is ignored
Date
Msg-id 27734.999882495@sss.pgh.pa.us
Whole thread Raw
In response to Bug #441: Index using INT8 data type is ignored  (pgsql-bugs@postgresql.org)
List pgsql-bugs
Tree view 
Try coercing your constants to int8 explicitly:

    ... WHERE int8col = 42::int8;

See the archives for more info about this.

            regards, tom lane

pgsql-bugs by date:

Previous
From: pgsql-bugs@postgresql.org
Date:
Subject: Bug #441: Index using INT8 data type is ignored
Next
From: grant
Date:
Subject: Re: Bug #441: Index using INT8 data type is ignored