From: Mike Mascari <mascarm@mascari.com>
To: Dann Corbit <DCorbit@connx.com>
Cc: Peter Eisentraut <peter_e@gmx.net>
Cc: PostgreSQL-development <pgsql-hackers@postgresql.org>
Subject: Re: Is indexing broken for bigint columns?
Date: Tue, 24 Feb 2004 19:37:14 -0500
Message-ID: <403BEE3A.10107@mascari.com> (raw)
In-Reply-To: <D90A5A6C612A39408103E6ECDD77B829408D0F@voyager.corporate.connx.com>
References: <D90A5A6C612A39408103E6ECDD77B829408D0F@voyager.corporate.connx.com>
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...>
> 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
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-hackers@postgresql.org
Cc: mascarm@mascari.com, DCorbit@connx.com, peter_e@gmx.net
Subject: Re: Is indexing broken for bigint columns?
In-Reply-To: <403BEE3A.10107@mascari.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