Received: from neptune.fr (titan.neptune.fr [194.2.77.2]) by hub.org (8.9.1/8.9.1) with ESMTP id EAA27358 for ; Wed, 23 Dec 1998 04:26:37 -0500 (EST) (envelope-from darold@neptune.fr) Received: from neptune.fr (palrel3.hp.com [156.153.255.226]) by neptune.fr (8.8.7/8.8.7) with ESMTP id KAA28883 for ; Wed, 23 Dec 1998 10:26:31 +0100 Message-ID: <3680B749.3B30CF42@neptune.fr> Date: Wed, 23 Dec 1998 10:26:33 +0100 From: darold X-Mailer: Mozilla 4.05 [en] (WinNT; I) MIME-Version: 1.0 To: pgsql-general@postgresql.org Subject: PB with Null string Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit Hi, I have tried this query to check if a field is empty: SELECT * FROM t_table WHERE s_string=''; where s_string is declared as text. But this doesn't work, why? Is there's an other way to do that ? I have also tried with NULL but I think it is not included in the 6.3.2... Thank, Gilles