RE: [HACKERS] int8 and index

> -----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