[postgis-users] how delete null value

[Fabio Renzo Panettieri]

On Thu, 2010-08-05 at 07:53 -0700, Akhilesh Gan wrote:
> how to delete null values in table for geometry column

Do you want to delete the complete record or just avoid the null?
If the later, I think NOT NULL constraint will do just fine.

If you want to delete the record its very easy.

DELETE from table_name
WHERE geometry_column IS NULL;

--
Fabio R. Panettieri
Software Architect
http://www.xoomcode.com