Skip site navigation (1) Skip section navigation (2)

Re: matching empty column

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 (view raw or flat)
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 

In response to

pgsql-novice by date

Next:From: Bruno Wolff IIIDate: 2006-08-24 19:01:10
Subject: Re: matching empty column
Previous:From: Alan HodgsonDate: 2006-08-24 17:31:29
Subject: Re: matching empty column

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group