Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-novice by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group