X-Original-To: pgsql-hackers-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.2]) by svr1.postgresql.org (Postfix) with ESMTP id 95071D1DEFC for ; Wed, 25 Feb 2004 00:39:09 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (neptune.hub.org [200.46.204.2]) (amavisd-new, port 10024) with ESMTP id 57864-06 for ; Tue, 24 Feb 2004 20:39:09 -0400 (AST) Received: from ms-smtp-02-eri0.ohiordc.rr.com (ms-smtp-02-smtplb.ohiordc.rr.com [65.24.5.136]) by svr1.postgresql.org (Postfix) with ESMTP id 1CE4CD1BAAD for ; Tue, 24 Feb 2004 20:39:06 -0400 (AST) Received: from enzo.mascari.com (dhcp065-024-156-214.columbus.rr.com [65.24.156.214]) by ms-smtp-02-eri0.ohiordc.rr.com (8.12.10/8.12.7) with ESMTP id i1P0citO006637; Tue, 24 Feb 2004 19:38:45 -0500 (EST) Received: from mascari.com (ferrari.mascari.com [192.168.2.1]) by enzo.mascari.com (8.12.8/8.12.8) with ESMTP id i1P0c7H6013456; Tue, 24 Feb 2004 19:38:07 -0500 Message-ID: <403BEE3A.10107@mascari.com> Date: Tue, 24 Feb 2004 19:37:14 -0500 From: Mike Mascari User-Agent: Mozilla/5.0 (Windows; U; WinNT4.0; en-US; rv:1.5) Gecko/20031007 X-Accept-Language: en-us, en MIME-Version: 1.0 To: Dann Corbit Cc: Peter Eisentraut , PostgreSQL-development Subject: Re: Is indexing broken for bigint columns? References: In-Reply-To: X-Enigmail-Version: 0.82.6.0 X-Enigmail-Supports: pgp-inline, pgp-mime Content-Type: text/plain; charset=us-ascii; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: Symantec AntiVirus Scan Engine X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200402/807 X-Sequence-Number: 50396 Dann Corbit wrote: > PostgreSQL is the only database that requires casts to do an index > lookup. Possibly (quite probably) true, but you don't show any evidence that SQL*Server, Oracle, or MySQL uses indexes either. Like I said before, Tom (of course) already has a fix is already in the development branch: http://groups.google.com/groups?hl=en&lr=&ie=UTF-8&oe=UTF-8&threadm=29832.1068682253%40sss.pgh.pa.us&rnum=1&prev=/groups%3Fhl%3Den%26lr%3D%26ie%3DUTF-8%26oe%3DUTF-8%26scoring%3Dd%26q%3Dbigint%2Bindex%2Bhackers%2Bpostgresql > > This is SQL*Server syntax: > ============================================================== ... > select * from foo where bar = 1 ... > This is Oracle syntax: > ============================================================== > SQL> select * from foo where bar = 1; ... > mysql> select * from foo where bar = 1; Mike Mascari