Re: matching empty column

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@yahoo.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