Received: from localhost (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id 9DC9E476064 for ; Wed, 22 Jan 2003 02:37:17 -0500 (EST) Received: from kant.catalyst.net.nz (203-79-123-35.adsl.paradise.net.nz [203.79.123.35]) by postgresql.org (Postfix) with ESMTP id 8148B47605F for ; Wed, 22 Jan 2003 02:37:15 -0500 (EST) Received: from 127.0.0.1 (ident=unknown) by kant.catalyst.net.nz with esmtp (masqmail 0.2.16) id 18bFRU-58n-00; Wed, 22 Jan 2003 20:37:00 +1300 Subject: Re: empty From: Andrew McMillan To: ryanne cruz Cc: pgsql-php@postgresql.org In-Reply-To: <1043219657.3e2e44c92917a@mail.up.edu.ph> References: <1043219657.3e2e44c92917a@mail.up.edu.ph> Content-Type: text/plain Organization: Message-Id: <1043221019.3119.196.camel@kant.mcmillan.net.nz> Mime-Version: 1.0 X-Mailer: Ximian Evolution 1.2.1 Date: 22 Jan 2003 20:36:59 +1300 Content-Transfer-Encoding: 7bit X-Virus-Scanned: by AMaViS new-20020517 X-Archive-Number: 200301/40 X-Sequence-Number: 1785 On Wed, 2003-01-22 at 20:14, ryanne cruz wrote: > hi list. > > i have a column which has some rows int it that has no data. how do i select > them? If the column has NULL values: SELECT column FROM table WHERE other_column IS NULL; or (if the column has blank values): SELECT column FROM table WHERE other_column = ''; Also, may I recommend: http://www.postgresql.org/idocs/index.php?user.html Regards, Andrew. -- --------------------------------------------------------------------- Andrew @ Catalyst .Net.NZ Ltd, PO Box 11-053, Manners St, Wellington WEB: http://catalyst.net.nz/ PHYS: Level 2, 150-154 Willis St DDI: +64(4)916-7201 MOB: +64(21)635-694 OFFICE: +64(4)499-2267 Survey for nothing with http://survey.net.nz/ ---------------------------------------------------------------------