RE: [HACKERS] int8 and index

From: "Hiroshi Inoue" <Inoue(at)tpf(dot)co(dot)jp>
To: "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:32:02
Message-ID: 000d01bf0656$82ebaa60$2801007e@cadzone.tpf.co.jp
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

> -----Original Message-----
> From: owner-pgsql-hackers(at)postgreSQL(dot)org
> [mailto:owner-pgsql-hackers(at)postgreSQL(dot)org]On Behalf Of Tatsuo Ishii
> Sent: Friday, September 24, 1999 3:12 PM
> To: pgsql-hackers(at)postgreSQL(dot)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(at)tpf(dot)co(dot)jp

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Tatsuo Ishii 1999-09-24 06:36:37 Re: [HACKERS] int8 and index
Previous Message Tatsuo Ishii 1999-09-24 06:12:17 int8 and index