X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [64.117.224.130]) by svr1.postgresql.org (Postfix) with ESMTP id A1303D1B51D for ; Wed, 1 Oct 2003 12:52:16 +0000 (GMT) Received: from svr1.postgresql.org ([64.117.224.193]) by localhost (neptune.hub.org [64.117.224.130]) (amavisd-new, port 10024) with ESMTP id 26840-01 for ; Wed, 1 Oct 2003 09:51:30 -0300 (ADT) Received: from mail.hive.nj2.inquent.com (mc.carriermail.com [205.178.180.9]) by svr1.postgresql.org (Postfix) with SMTP id 3E208D1B526 for ; Wed, 1 Oct 2003 09:51:11 -0300 (ADT) Received: (qmail 5784 invoked from network); 1 Oct 2003 12:51:05 -0000 Received: from unknown (HELO ?10.0.2.7?) (216.208.117.7) by 205.178.180.9 with SMTP; 1 Oct 2003 12:51:05 -0000 Subject: Re: What is the fastest null WHERE From: Rod Taylor To: Mindaugas Riauba Cc: Postgresql Performance In-Reply-To: <07c001c38815$29277b90$f20214ac@bite.lt> References: <07c001c38815$29277b90$f20214ac@bite.lt> Content-Type: multipart/signed; micalg=pgp-sha1; protocol="application/pgp-signature"; boundary="=-LoyjT9L9QCuLRJ620F4r" Message-Id: <1065012705.83185.78.camel@jester> Mime-Version: 1.0 X-Mailer: Ximian Evolution 1.4.5 Date: Wed, 01 Oct 2003 08:51:46 -0400 X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200310/13 X-Sequence-Number: 3761 --=-LoyjT9L9QCuLRJ620F4r Content-Type: text/plain Content-Transfer-Encoding: quoted-printable On Wed, 2003-10-01 at 08:11, Mindaugas Riauba wrote: > While writing web application I found that it would > be very nice for me to have "null" WHERE clause. Like > WHERE 1=3D1. Then it is easy to concat additional > conditions just using $query . " AND col=3Dfalse" syntax. >=20 > But which of the possible "null" clauses is the fastest > one? WHERE true AND .... --=-LoyjT9L9QCuLRJ620F4r Content-Type: application/pgp-signature; name=signature.asc Content-Description: This is a digitally signed message part -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.2.3 (FreeBSD) iD8DBQA/es3h6DETLow6vwwRAgyzAKCEExsWbRYslQU14sPzBPcGsxgEQgCcDXjI 74JTk9DH9yeFIwtLRU7G57g= =rm8u -----END PGP SIGNATURE----- --=-LoyjT9L9QCuLRJ620F4r--