> -----Original Message-----
> From: owner-pgsql-hackers@postgreSQL.org
> [mailto:owner-pgsql-hackers@postgreSQL.org]On Behalf Of Tatsuo Ishii
> Sent: Friday, September 24, 1999 3:12 PM
> To: pgsql-hackers@postgreSQL.org
> Subject: [HACKERS] int8 and index
>
>
> Do we have problems with int8 indexes? Seems select on an int8 does
> not use an index.
>
How about select .. from .. where .. = ..::int8; ?
Without ::int8 PostgreSQL doesn't use int8 indexes.
Regards.
Hiroshi Inoue
Inoue@tpf.co.jp