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 |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
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
From | Date | Subject | |
---|---|---|---|
Next Message | Devrim GUNDUZ | 2004-09-29 16:57:19 | Re: DELETE EMPTY ROWS |
Previous Message | Paulo Nievierowski | 2004-09-28 22:27:17 | SELECT with Function |