Re: [HACKERS] int8 and index

From: Tatsuo Ishii <t-ishii(at)sra(dot)co(dot)jp>
To: "Hiroshi Inoue" <Inoue(at)tpf(dot)co(dot)jp>
Cc: "Tatsuo Ishii" <t-ishii(at)sra(dot)co(dot)jp>, pgsql-hackers(at)postgreSQL(dot)org
Subject: Re: [HACKERS] int8 and index
Date: 1999-09-24 06:36:37
Message-ID: 199909240636.PAA29772@srapc451.sra.co.jp
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Browse pgsql-hackers by date

  From Date Subject
Next Message Daniel Péder 1999-09-24 09:45:32 postgres startup script modification (Linux RedHat)
Previous Message Hiroshi Inoue 1999-09-24 06:32:02 RE: [HACKERS] int8 and index