Re: DELETE EMPTY ROWS - Mailing list 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-----