RE: [HACKERS] int8 and index
От | Hiroshi Inoue |
---|---|
Тема | RE: [HACKERS] int8 and index |
Дата | |
Msg-id | 001601bf0884$de79e920$2801007e@cadzone.tpf.co.jp обсуждение исходный текст |
Ответ на | Re: [HACKERS] int8 and index (Bruce Momjian <maillist@candle.pha.pa.us>) |
Ответы |
Re: [HACKERS] int8 and index
|
Список | pgsql-hackers |
> -----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
В списке pgsql-hackers по дате отправления: