hi list.

i have a column which has some rows int it that has no data. how do i select
them?

thanks!

---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to majordomo [at] postgresql.org so that your
message can get through to the mailing list cleanly

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 [at] 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 [at] postgresql.org

Thanks again.

Quoting Andrew McMillan <andrew [at] catalyst.net.nz>:

> 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 [at] 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 [at] postgresql.org
>



---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to majordomo [at] postgresql.org