Received: from www2.intellicast.com ([208.194.150.24]) by hub.org (8.10.1/8.10.1) with ESMTP id e7EH3Ow08857 for ; Mon, 14 Aug 2000 13:03:25 -0400 (EDT) Received: from wsicorp.com (ravens.wsicorp.com [147.81.80.26]) by www2.intellicast.com (980427.SGI.8.8.8/970903.SGI.AUTOCF) via ESMTP id NAA00564; Mon, 14 Aug 2000 13:02:32 -0400 (EDT) Message-ID: <39982628.D75E03FD@wsicorp.com> Date: Mon, 14 Aug 2000 13:02:32 -0400 From: Kate Collins Organization: Weather Services International X-Mailer: Mozilla 4.73 [en] (WinNT; U) X-Accept-Language: en MIME-Version: 1.0 To: Web Manager CC: pgsql-sql@postgresql.org Subject: Re: select an entry with a NULL date field References: <3997FC0F.96ACA1A8@inter-resa.com> Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit X-Archive-Number: 200008/91 Try: select entry_id from tbl_date where date02 is null; Kate Web Manager wrote: > 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 -- ================================================= Katherine (Kate) L. Collins Senior Software Engineer/Meteorologist Weather Services International (WSI Corporation) 4 Federal Street Billerica, MA 01821 EMAIL: klcollins@wsicorp.com PHONE: (978) 670-5110 FAX: (978) 670-5100 http://www.intellicast.com