DELETE EMPTY ROWS
От | Kumar S |
---|---|
Тема | DELETE EMPTY ROWS |
Дата | |
Msg-id | 20040929160347.93237.qmail@web51405.mail.yahoo.com обсуждение исходный текст |
Ответ на | SELECT with Function (Paulo Nievierowski <postgres@steffenpneus.com.br>) |
Ответы |
Re: DELETE EMPTY ROWS
|
Список | 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
В списке pgsql-novice по дате отправления: