On Wed, 1 Aug 2001, hubert depesz lubaczewski wrote:
> hi
> i just checked a friends database and it seems that INT8 fields are not
> indexable.
> i mean:
> he has a table with several fields. one of this fields is int8 with unique
> index.
> we have aproximately 100000 records in this table, database is vacuumed, but
> the index doesn't seem to work when i do something like
>
> explain select * from table where int8field = xxxx;
>
If the index exists the problem might be that 'xxxx' is not an int8 value.
Try select * from table where int8field = xxxx::int8;.
- Einar Karttunen