From: | Srinivas Iyyer <srini_iyyer_bio(at)yahoo(dot)com> |
---|---|
To: | Srinivas Iyyer <srini_iyyer_bio(at)yahoo(dot)com>, pgsql-novice(at)postgresql(dot)org |
Subject: | Re: matching empty column |
Date: | 2006-08-24 17:33:37 |
Message-ID: | 20060824173337.98268.qmail@web38107.mail.mud.yahoo.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-novice |
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
From | Date | Subject | |
---|---|---|---|
Next Message | Bruno Wolff III | 2006-08-24 19:01:10 | Re: matching empty column |
Previous Message | Alan Hodgson | 2006-08-24 17:31:29 | Re: matching empty column |