Re: [HACKERS] int8 and index - Mailing list pgsql-hackers

From Tatsuo Ishii
Subject Re: [HACKERS] int8 and index
Date
Msg-id 199909240636.PAA29772@srapc451.sra.co.jp
Whole thread Raw
In response to RE: [HACKERS] int8 and index  ("Hiroshi Inoue" <Inoue@tpf.co.jp>)
Responses Re: [HACKERS] int8 and index
List pgsql-hackers
>> 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.

Oops. I forgot about that! Thanks.
--
Tatsuo Ishii


pgsql-hackers by date:

Previous
From: "Hiroshi Inoue"
Date:
Subject: RE: [HACKERS] int8 and index
Next
From: Peter Eisentraut
Date:
Subject: psql issues