RE: [HACKERS] int8 and index

> -----Original Message-----
> From: Bruce Momjian [mailto:maillist(at)candle(dot)pha(dot)pa(dot)us]
> Sent: Monday, September 27, 1999 9:47 AM
> To: Tom Lane
> Cc: t-ishii(at)sra(dot)co(dot)jp; Hiroshi Inoue; pgsql-hackers(at)postgreSQL(dot)org
> Subject: Re: [HACKERS] int8 and index
>
>
> > Tatsuo Ishii <t-ishii(at)sra(dot)co(dot)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(at)tpf(dot)co(dot)jp