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


_______________________________________________
postgis-users mailing list
[email protected]
http://postgis.refractions.net/mailman/listinfo/postgis-users

Reply via email to