| From: | Srinivas Iyyer <srini_iyyer_bio(at)yahoo(dot)com> |
|---|---|
| To: | pgsql-novice(at)postgresql(dot)org |
| Subject: | matching empty column |
| Date: | 2006-08-24 17:27:16 |
| Message-ID: | 20060824172716.91659.qmail@web38108.mail.mud.yahoo.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-novice |
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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Alan Hodgson | 2006-08-24 17:31:29 | Re: matching empty column |
| Previous Message | Jasbinder Bali | 2006-08-24 16:08:58 | Dynamic loading (datatype mismatch) |