BUG #1984: automatic casting for using indexes on bigint - Mailing list pgsql-bugs

From Atanas Hristov
Subject BUG #1984: automatic casting for using indexes on bigint
Date
Msg-id 20051021135016.A8B2BF147A@svr2.postgresql.org
Whole thread Raw
Responses Re: BUG #1984: automatic casting for using indexes on bigint
List pgsql-bugs
The following bug has been logged online:

Bug reference:      1984
Logged by:          Atanas Hristov
Email address:      atanashristov@hotmail.com
PostgreSQL version: 8.1
Operating system:   FreeBSD5
Description:        automatic casting for using indexes on bigint
Details:

Maybe it is more convient to cast automaticly in sich a case? :

personalities=> create table foo (id bigint);
CREATE TABLE
personalities=> explain analyze select * from foo where id = 0;
                                         QUERY PLAN
----------------------------------------------------------------------------
-----------------
 Seq Scan on foo  (cost=0.00..0.00 rows=1 width=8) (actual time=0.007..0.007
rows=0 loops=1)
   Filter: (id = 0)
 Total runtime: 21.140 ms
(3 rows)

personalities=> explain analyze select * from foo where cast(id as bigint) =
0;
                                         QUERY PLAN
----------------------------------------------------------------------------
-----------------
 Seq Scan on foo  (cost=0.00..0.00 rows=1 width=8) (actual time=0.006..0.006
rows=0 loops=1)
   Filter: (id = 0)
 Total runtime: 0.077 ms
(3 rows)


best regards and thank you for the great database!!!

pgsql-bugs by date:

Previous
From: "Jari Aalto"
Date:
Subject: BUG #1986: Please include ONE BIG .txt and .HTML file in *docs*.tar.gz
Next
From: Tom Lane
Date:
Subject: Re: BUG #1984: automatic casting for using indexes on bigint