From: | "Atanas Hristov" <atanashristov(at)hotmail(dot)com> |
---|---|
To: | pgsql-bugs(at)postgresql(dot)org |
Subject: | BUG #1984: automatic casting for using indexes on bigint |
Date: | 2005-10-21 13:50:16 |
Message-ID: | 20051021135016.A8B2BF147A@svr2.postgresql.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-bugs |
The following bug has been logged online:
Bug reference: 1984
Logged by: Atanas Hristov
Email address: atanashristov(at)hotmail(dot)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!!!
From | Date | Subject | |
---|---|---|---|
Next Message | Magnus Hagander | 2005-10-21 14:08:25 | Re: BUG #1983: Installation fails when Windows user principal is member of local Administrators group |
Previous Message | Dave Page | 2005-10-21 13:46:56 | Re: BUG #1980: Create new Replication error when click toolbar "create a new.." on pgAdmin III 1.4.0Beta2 |