Re: how to remove empty rows

From: "Jean-Yves F(dot) Barbier" <12ukwn(at)gmail(dot)com>
To: pgsql-novice(at)postgresql(dot)org
Subject: Re: how to remove empty rows
Date: 2011-04-26 21:44:22
Message-ID: 20110426234422.78481c70@anubis.defcon1
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

On Tue, 26 Apr 2011 22:37:56 +0100, e-letter <inpost(at)gmail(dot)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

In response to

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Lew 2011-04-27 12:52:20 Re: how to remove empty rows
Previous Message e-letter 2011-04-26 21:37:56 how to remove empty rows