| From: | Devrim GUNDUZ <devrim(at)gunduz(dot)org> |
|---|---|
| To: | Kumar S <ps_postgres(at)yahoo(dot)com> |
| Cc: | pgsql-novice(at)postgresql(dot)org |
| Subject: | Re: DELETE EMPTY ROWS |
| Date: | 2004-09-29 16:57:19 |
| Message-ID: | Pine.LNX.4.61.0409291956030.22024@emo.org.tr |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-novice |
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
Hi,
On Wed, 29 Sep 2004, Kumar S wrote:
> How can I delete empty rows in a table that I have.
<snip>
> In this table columns 3,6,9 and 10 are completely
> empty. I tried
>
> =>DELETE from my_table where fc_huge_name = ' NULL';
DELETE FROM my_table WHERE fc_huge_name IS NULL;
will work I think.
Regards,
- --
Devrim GUNDUZ
devrim~gunduz.org devrim.gunduz~linux.org.tr
http://www.tdmsoft.com
http://www.gunduz.org
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.2.1 (GNU/Linux)
iD8DBQFBWulwtl86P3SPfQ4RAhx7AJ9GnQD/9zCbxKDESs3ye2OmAmCoaACaArzF
6JDwhKK4BwyMI9nSI6ez5Tk=
=zghJ
-----END PGP SIGNATURE-----
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Eduardo Vázquez Rodríguez | 2004-09-30 00:00:17 | Perl and Postgres |
| Previous Message | Kumar S | 2004-09-29 16:03:47 | DELETE EMPTY ROWS |