Postgres Pro
Downloads
Home   >   mailing lists

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

From Hiroshi Inoue
Subject RE: [HACKERS] int8 and index
Date
Msg-id 000d01bf0656$82ebaa60$2801007e@cadzone.tpf.co.jp
Whole thread Raw
In response to int8 and index  (Tatsuo Ishii <t-ishii@sra.co.jp>)
Responses Re: [HACKERS] int8 and index
List pgsql-hackers
Tree view 
> -----Original Message-----
> From: owner-pgsql-hackers@postgreSQL.org
> [mailto:owner-pgsql-hackers@postgreSQL.org]On Behalf Of Tatsuo Ishii
> Sent: Friday, September 24, 1999 3:12 PM
> To: pgsql-hackers@postgreSQL.org
> Subject: [HACKERS] int8 and index
> 
> 
> 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.

Regards.

Hiroshi Inoue
Inoue@tpf.co.jp

pgsql-hackers by date:

Previous
From: Tatsuo Ishii
Date:
Subject: int8 and index
Next
From: Tatsuo Ishii
Date:
Subject: Re: [HACKERS] int8 and index