From: Neil Conway <neilc@samurai.com>
To: Andrew Sullivan <ajs@crankycanuck.ca>
Cc: pgsql-performance@postgresql.org
Subject: Re: Using bigint needs explicit cast to use the index
Date: Mon, 08 Mar 2004 11:22:56 -0500
Message-ID: <404C9DE0.7000200@samurai.com> (raw)
In-Reply-To: <20040308160525.GA25077@phlogiston.dyndns.org>
References: <001101c404a3$fb34d320$fd08a8c0@steve>
<20040308160525.GA25077@phlogiston.dyndns.org>
Andrew Sullivan wrote:
> "Intended", no. "Expected", yes. This topic has had the best
> Postgres minds work on it, and so far nobody's come up with a
> solution.
Actually, this has already been fixed in CVS HEAD (as I mentioned in
this thread yesterday). To wit:
nconway=# create table t1 (a int8);
CREATE TABLE
nconway=# create index t1_a_idx on t1 (a);
CREATE INDEX
nconway=# explain select * from t1 where a = 5;
QUERY PLAN
--------------------------------------------------------------------
Index Scan using t1_a_idx on t1 (cost=0.00..17.07 rows=5 width=8)
Index Cond: (a = 5)
(2 rows)
nconway=# select version();
version
------------------------------------------------------------------------------------
PostgreSQL 7.5devel on i686-pc-linux-gnu, compiled by GCC gcc (GCC)
3.3.3 (Debian)
(1 row)
-Neil
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: neilc@samurai.com, ajs@crankycanuck.ca
Subject: Re: Using bigint needs explicit cast to use the index
In-Reply-To: <404C9DE0.7000200@samurai.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox