Received: from ant.utdt (acad.utdt.edu [200.41.62.131]) by hub.org (8.10.1/8.10.1) with ESMTP id e7EH8hw10671 for ; Mon, 14 Aug 2000 13:08:46 -0400 (EDT) Received: (from mig@localhost) by ant.utdt (8.9.3/8.9.3) id OAA08698; Mon, 14 Aug 2000 14:06:44 -0400 Date: Mon, 14 Aug 2000 14:06:44 -0400 Message-Id: <200008141806.OAA08698@ant.utdt> X-Authentication-Warning: ant.utdt: mig set sender to Miguel Sofer using -f From: " To: web@inter-resa.com CC: pgsql-sql@postgresql.org In-reply-to: <3997FC0F.96ACA1A8@inter-resa.com> (message from Web Manager on Mon, 14 Aug 2000 10:02:55 -0400) Subject: Re: select an entry with a NULL date field References: <3997FC0F.96ACA1A8@inter-resa.com> X-Archive-Number: 200008/92 Try select entry_id from tbl_date where date_02 is NULL; miguel sofer > >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 >