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

DELETE EMPTY ROWS

From: Kumar S <ps_postgres(at)yahoo(dot)com>
To: pgsql-novice(at)postgresql(dot)org
Subject: DELETE EMPTY ROWS
Date: 2004-09-29 16:03:47
Message-ID: 20040929160347.93237.qmail@web51405.mail.yahoo.com (view raw or flat)
Thread:
Lists: pgsql-novice
Hi, 
 How can I delete empty rows in a table that I have. 
 f_huge_id | f_huge_name | f_huge_badge | f_huge_city
|    f_huge_edu
-----------+-------------+--------------+-------------+-------------------
         1 | Apparao     | A12345       | Anakapalli 
| Brown University
         2 | Paparao     | A23456       | Madugula   
| Town University
         3 |             |              |            
|
         4 | Chinnarao   | A34456       | Uppalada   
| Sink University
         5 | Gangaraju   | B34657       | Srikakulam 
| Kulam University
         6 |             |              |            
|
         7 | Appalaraju  | A34457       | Chodavaram 
| AMAL college
         8 | Kanakarao   | A56788       | Pisinikada 
| Temple University
         9 |             |              |            
|
        10 |             |              |            
|


In this table columns 3,6,9 and 10 are completely
empty. I tried

=>DELETE from my_table where fc_huge_name = ' NULL';
DELTE 0

However nothing is deleted. 
Is there some command or statement that I am missing. 
Can any one suggest some way. 

Thank you. 

Kumar.



__________________________________________________
Do You Yahoo!?
Tired of spam?  Yahoo! Mail has the best spam protection around 
http://mail.yahoo.com 

In response to

Responses

pgsql-novice by date

Next:From: Devrim GUNDUZDate: 2004-09-29 16:57:19
Subject: Re: DELETE EMPTY ROWS
Previous:From: Paulo NievierowskiDate: 2004-09-28 22:27:17
Subject: SELECT with Function

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