pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  
help / color / mirror / Atom feed
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



view thread (6+ messages)  latest in thread

Message-ID: <404C9DE0.7000200@samurai.com>
Permalink:  ../404C9DE0.7000200@samurai.com/
Also on:    postgresql.org/message-id/404C9DE0.7000200@samurai.com

 · 

reply

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