Re: empty

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