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
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

In response to

Responses

Browse pgsql-novice by date

  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