Received: from localhost (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id D4DAD476C67 for ; Wed, 22 Jan 2003 02:43:39 -0500 (EST) Received: from mail02.up.edu.ph (unknown [210.14.43.1]) by postgresql.org (Postfix) with SMTP id 9EE844765EA for ; Wed, 22 Jan 2003 02:43:38 -0500 (EST) Received: (qmail 10310 invoked by uid 504); 22 Jan 2003 08:15:38 -0000 Received: from ryanne.cruz@up.edu.ph by web2 with qmail-scanner-1.01 (update: v4243 15 Jan 2003. Clean. Processed in 1.008612 secs); 22 Jan 2003 08:15:38 -0000 Received: from unknown (HELO b01.mail.up.edu.ph) (10.16.3.1) by 10.16.3.144 with SMTP; 22 Jan 2003 08:15:36 -0000 Received: (qmail 16982 invoked by uid 504); 22 Jan 2003 07:47:13 -0000 Received: from ryanne.cruz@up.edu.ph by b01 with qmail-scanner-1.01 (update: v4243 15 Jan 2003. Clean. Processed in 0.568794 secs); 22 Jan 2003 07:47:13 -0000 Received: from unknown (HELO localhost) ([10.16.3.5]) (envelope-sender ) by 10.16.3.1 (qmail-ldap-1.03) with SMTP for ; 22 Jan 2003 07:47:12 -0000 Received: from 10.33.187.83 ( [10.33.187.83]) as user rocruz1@b04.mail.up.edu.ph by mail.up.edu.ph with HTTP; Wed, 22 Jan 2003 15:57:29 +0800 Message-ID: <1043222249.3e2e4ee9e2a3a@mail.up.edu.ph> Date: Wed, 22 Jan 2003 15:57:29 +0800 From: ryanne cruz To: pgsql-php@postgresql.org, Andrew McMillan Subject: Re: empty References: <1043219657.3e2e44c92917a@mail.up.edu.ph> <1043221019.3119.196.camel@kant.mcmillan.net.nz> In-Reply-To: <1043221019.3119.196.camel@kant.mcmillan.net.nz> MIME-Version: 1.0 Content-Type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: 8bit User-Agent: Internet Messaging Program (IMP) 3.1 X-Originating-IP: 10.33.187.83 X-Virus-Scanned: by AMaViS new-20020517 X-Archive-Number: 200301/42 X-Sequence-Number: 1787 Thanks again. Quoting Andrew McMillan : > 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/ > --------------------------------------------------------------------- > > > ---------------------------(end of broadcast)--------------------------- > TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org >