Received: from maia.hub.org (unknown [200.46.204.183]) by mail.postgresql.org (Postfix) with ESMTP id EB5B76357A7 for ; Wed, 10 Jun 2009 09:19:39 -0300 (ADT) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 65481-03 for ; Wed, 10 Jun 2009 09:19:38 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from wavecable.net (mail3.wavecable.com [24.113.32.25]) by mail.postgresql.org (Postfix) with ESMTP id 993C2633E54 for ; Wed, 10 Jun 2009 09:19:36 -0300 (ADT) Received: from [76.14.161.10] (HELO [192.168.1.215]) by wavecable.net (CommuniGate Pro SMTP 4.2.8) with ESMTP id 172333621 for pgsql-sql@postgresql.org; Wed, 10 Jun 2009 05:07:14 -0700 From: johnf To: pgsql-sql@postgresql.org Subject: setting the where clause Date: Wed, 10 Jun 2009 05:19:34 -0700 User-Agent: KMail/1.9.6 (enterprise 20070904.708012) MIME-Version: 1.0 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: 7bit Content-Disposition: inline Message-Id: <200906100519.34171.jfabiani@yolo.com> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0 tagged_above=0 required=5 tests=none X-Spam-Level: X-Archive-Number: 200906/45 X-Sequence-Number: 32650 Hi, I'm am programming in python using the Dabo modules. www.dabodev.com if your interested. Dabo is a framework that provides an easy way to build desktop app's. To clear a data entry form. I have been setting the where clause to "where 1=0". This of course retrieves 0 records and my form will display nothing. It has been suggested that it might be better to set the where clause to a primary key value that does not exist in the table "where PK = -9999999". I wonder what you guys think. How might it effect performance? -- John Fabiani