> -----Original Message-----
> From: Bruce Momjian [mailto:maillist@candle.pha.pa.us]
> Sent: Monday, September 27, 1999 9:47 AM
> To: Tom Lane
> Cc: t-ishii@sra.co.jp; Hiroshi Inoue; pgsql-hackers@postgreSQL.org
> Subject: Re: [HACKERS] int8 and index
>
>
> > Tatsuo Ishii <t-ishii@sra.co.jp> writes:
> > >> How about select .. from .. where .. = ..::int8; ?
> > >>
> > >> Without ::int8 PostgreSQL doesn't use int8 indexes.
> >
> > > Oops. I forgot about that! Thanks.
> >
> > Yes, this is on the TODO list (although I think TODO just mentions
> > the equivalent problem for int2).
> >
>
> int8 mention added.
>
There may be a little difference.
int4 -> int8 never fails.
But int4 -> int2 fails if abs(int4) > 32768.
select .. from .. where int2_column = 32769;
should return 0 rows or cause an elog(ERROR) ?
Regards.
Hiroshi Inoue
Inoue@tpf.co.jp