how to remove empty rows

From: e-letter <inpost(at)gmail(dot)com>
To: pgsql-novice(at)postgresql(dot)org
Subject: how to remove empty rows
Date: 2011-04-26 21:37:56
Message-ID: BANLkTi=Gm0e87fvFEPcLZv1NNT0GtTJ5HA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

Readers,

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?

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Jean-Yves F. Barbier 2011-04-26 21:44:22 Re: how to remove empty rows
Previous Message Tom Lane 2011-04-26 18:05:14 Re: Getting null values in an update statement