Received: from post.mail.demon.net (post-11.mail.demon.net [194.217.242.40]) by hub.org (8.8.8/8.8.8) with ESMTP id RAA10649 for ; Sat, 19 Sep 1998 17:49:46 -0400 (EDT) (envelope-from ian@iprogc.demon.co.uk) Received: from [158.152.78.82] (helo=iprogc.demon.co.uk) by post.mail.demon.net with esmtp (Exim 2.03 #1) id 0zKUsv-0006h3-00 for pgsql-sql@postgresql.org; Sat, 19 Sep 1998 21:49:42 +0000 Message-ID: <360427CF.F55E5157@iprogc.demon.co.uk> Date: Sat, 19 Sep 1998 22:53:19 +0100 From: Ian Johnston X-Mailer: Mozilla 4.05 [en] (Win95; I) MIME-Version: 1.0 To: pgsql-sql@postgresql.org Subject: date problem Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit How do I select all fields where the 'date' entry is not set. Eg. items who do not have a date stored in a date defined field ? Ian Johnston