Re: matching empty column

[Srinivas Iyyer <srini_iyyer_bio(at)yahoo(dot)com>]

oops ! sorry. I should not have written before
thinking and referring to documentation. 

select * from TABLE where mid is NULL;



--- Srinivas Iyyer <srini_iyyer_bioop(at)yahoo(dot)com>
wrote:

> hello group:
> 
> I have a table that has 500,000 rows. 
> 
>  tar_id | mid   | seq_id | lscore
> --------+-------+--------+--------
>   32014 |       |  50473 |    814
>   32015 |    67 |  50473 |    814
>   32016 |   461 |  50473 |    814
>   32017 |       |  52964 |    857
>   32018 |   428 |  52964 |    822
>   32019 |    98 |  51208 |    737
>   32020 |   435 |  51208 |    737
>   32021 |       |  51208 |    764
>   32022 |    98 |  41066 |    759
>   32023 |   431 |  41066 |    593
>   32024 |   250 |  41066 |    659
> 
> The mid column is empty in certain places. how can I
> search if there are empty spaces in mid. 
> 
> Thanks.
> 
> 
> __________________________________________________
> Do You Yahoo!?
> Tired of spam?  Yahoo! Mail has the best spam
> protection around 
> http://mail.yahoo.com 
> 
> ---------------------------(end of
> broadcast)---------------------------
> TIP 5: don't forget to increase your free space map
> settings
> 


__________________________________________________
Do You Yahoo!?
Tired of spam?  Yahoo! Mail has the best spam protection around 
http://mail.yahoo.com