Received: from field.videotron.net (field.videotron.net [205.151.222.108]) by hub.org (8.10.1/8.10.1) with ESMTP id e7EE6Mu40253 for ; Mon, 14 Aug 2000 10:06:22 -0400 (EDT) Received: from inter-resa.com ([24.200.227.43]) by field.videotron.net (Sun Internet Mail Server sims.3.5.1999.12.14.10.29.p8) with ESMTP id <0FZA00DX3CEDVO@field.videotron.net> for pgsql-sql@postgresql.org; Mon, 14 Aug 2000 10:03:49 -0400 (EDT) Date: Mon, 14 Aug 2000 10:02:55 -0400 From: Web Manager Subject: select an entry with a NULL date field To: pgsql-sql@postgresql.org Message-id: <3997FC0F.96ACA1A8@inter-resa.com> Organization: INTER-Res@ tourism network MIME-version: 1.0 X-Mailer: Mozilla 4.72 [en] (X11; U; Linux 2.2.12 i386) Content-type: text/plain; charset=us-ascii Content-transfer-encoding: 7bit X-Accept-Language: en X-Archive-Number: 200008/90 Hello, I have a problem with PostgreSQL when I try to select or delete an entry with an empty date. That's a typical entry Table tbl_date ----------------------------- entry_id 154 date_01 2000-01-15 date_02 this date is NULL name my_test ----------------------------- I want to select every entry containing date_02 as NULL I tried : >select entry_id from tbl_date where date_02=NULL; ERROR: parser: parse error at or near "null" >select entry_id from tbl_date where date_02=''; Not work, that's a wrong date format >select entry_id from tbl_date where date_02=""; Not work, "" considered as an attribute Thank you for your time! -- ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Marc Andre Paquin