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

Re: matching empty column

From: Alan Hodgson <ahodgson(at)simkin(dot)ca>
To: pgsql-novice(at)postgresql(dot)org
Subject: Re: matching empty column
Date: 2006-08-24 17:31:29
Message-ID: 200608241031.29263@hal.medialogik.com (view raw or flat)
Thread:
Lists: pgsql-novice
On Thursday 24 August 2006 10:27, Srinivas Iyyer <srini_iyyer_bio(at)yahoo(dot)com> 
wrote:
>  tar_id | mid   | seq_id | lscore
> --------+-------+--------+--------
>   32014 |       |  50473 |    814
>   32015 |    67 |  50473 |    814
> The mid column is empty in certain places. how can I
> search if there are empty spaces in mid.
>

select tar_id from table where mid is null;

(assuming it's a numeric and not a text field set to '')

-- 
Alan

In response to

pgsql-novice by date

Next:From: Srinivas IyyerDate: 2006-08-24 17:33:37
Subject: Re: matching empty column
Previous:From: Srinivas IyyerDate: 2006-08-24 17:27:16
Subject: matching empty column

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