X-Original-To: pgsql-bugs@postgresql.org Received: from localhost (developer.postgresql.org [64.117.224.193]) by developer.postgresql.org (Postfix) with ESMTP id CD335921B97 for ; Tue, 27 May 2003 09:56:53 -0400 (EDT) Received: from developer.postgresql.org ([64.117.224.193]) by localhost (developer.postgresql.org [64.117.224.193:10024]) (amavisd-new) with ESMTP id 72730-01 for ; Tue, 27 May 2003 09:56:52 -0400 (EDT) Received: from tomts21-srv.bellnexxia.net (tomts21.bellnexxia.net [209.226.175.183]) by developer.postgresql.org (Postfix) with ESMTP id AB529921B89 for ; Tue, 27 May 2003 09:56:51 -0400 (EDT) Received: from [10.0.2.5] ([216.208.117.7]) by tomts21-srv.bellnexxia.net (InterMail vM.5.01.05.32 201-253-122-126-132-20030307) with ESMTP id <20030527135648.MXZF2574.tomts21-srv.bellnexxia.net@[10.0.2.5]>; Tue, 27 May 2003 09:56:48 -0400 Subject: Re: index not used for bigint without explicit cast From: Rod Taylor To: Dave E Martin XXIII Cc: pgsql-bugs@postgresql.org In-Reply-To: <3ED2E46C.2060507@dave.to> References: <3ED2E46C.2060507@dave.to> Content-Type: multipart/signed; micalg=pgp-sha1; protocol="application/pgp-signature"; boundary="=-MnzdBHg0Vq3KFBiUoy4P" Organization: Message-Id: <1054043810.93507.1.camel@jester> Mime-Version: 1.0 X-Mailer: Ximian Evolution 1.2.4 Date: 27 May 2003 09:56:51 -0400 X-Virus-Scanned: by amavisd-new X-Archive-Number: 200305/94 X-Sequence-Number: 6055 --=-MnzdBHg0Vq3KFBiUoy4P Content-Type: text/plain Content-Transfer-Encoding: quoted-printable > explain analyze select * from connection_data where id=3D23457; Quote the number or cast it to int8. id=3D'23457' or id=3Dcast(23457 as int8) PostgreSQL has a hard time with mixed datatypes and indexscans at the moment. --=20 Rod Taylor PGP Key: http://www.rbt.ca/rbtpub.asc --=-MnzdBHg0Vq3KFBiUoy4P Content-Type: application/pgp-signature; name=signature.asc Content-Description: This is a digitally signed message part -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.2.2 (FreeBSD) iD8DBQA+026i6DETLow6vwwRAkLWAJ9bVjXI2YD4Z/c2TSNq6mDCHcZRjQCaAijk xzKO/L4qZ3MBSI4BQ6VD6qE= =4Nyw -----END PGP SIGNATURE----- --=-MnzdBHg0Vq3KFBiUoy4P--