Postgres Pro
Downloads
Home   >   mailing lists

matching empty column - Mailing list pgsql-novice

From Srinivas Iyyer
Subject matching empty column
Date
Msg-id 20060824172716.91659.qmail@web38108.mail.mud.yahoo.com
Whole thread Raw
Responses Re: matching empty column  (Srinivas Iyyer <srini_iyyer_bio@yahoo.com>)
Re: matching empty column  (Alan Hodgson <ahodgson@simkin.ca>)
Re: matching empty column  (Bruno Wolff III <bruno@wolff.to>)
List pgsql-novice
Tree view 
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

pgsql-novice by date:

Previous
From: "Jasbinder Bali"
Date:
Subject: Dynamic loading (datatype mismatch)
Next
From: Srinivas Iyyer
Date:
Subject: Re: matching empty column