[postgis-users] Make GeomFromText() return NULL on ERROR

Andreas Kalsch andreaskalsch at gmx.de
Fri Aug 7 09:54:30 PDT 2009


I load many geometries at once into a table and create them from WKT.
The SELECT clause will throw an error, if there is any error in a geometry.
The error is caused by ST_GeomFromText().

Is there a flag I can set to make the function simply return NULL 
instead of throwing an error?

ST_IsValid() will just validate Geometry objects but no WKTs.

Best,

Andi



More information about the postgis-users mailing list