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/ ---------------------------------------------------------------------
