Re: how to remove empty rows - Mailing list pgsql-novice

From Jean-Yves F. Barbier
Subject Re: how to remove empty rows
Date
Msg-id 20110426234422.78481c70@anubis.defcon1
Whole thread Raw
In response to how to remove empty rows  (e-letter <inpost@gmail.com>)
Responses Re: how to remove empty rows
List pgsql-novice
On Tue, 26 Apr 2011 22:37:56 +0100, e-letter <inpost@gmail.com> wrote:


> The command 'INSERT INTO' was used to enter the sum of a mathematical
> function into a table. On a condition, the result was null, causing
> the creation of an empty row in the table.
>
> Using tho command 'DELETE' with the expression:
>
> ...=NULL;
>
> does not remove the empty row. How to remove please?

NULL is *NOT* a value; use ISNULL to test.


--
A diplomat is man who always remembers a woman's birthday but never her age.
        -- Robert Frost

pgsql-novice by date:

Previous
From: e-letter
Date:
Subject: how to remove empty rows
Next
From: Lew
Date:
Subject: Re: how to remove empty rows