[postgis-users] Nitpicking on empty geometries

Rolf A. de By deby at itc.nl
Thu Jun 12 06:33:35 PDT 2008

Greetings all,

My st_intersection() of two multipolygons returns an empty geometry: no 
problems, as it should.  When I ask for its st_geometrytype() I am told 
it is "ST_Geometry", and I can live with that.  When I ask for its 
st_astext() I get "GEOMETRYCOLLECTION EMPTY," and that by itself I can 
also live with.  However, in combination I find those answers 
inconsistent and potentially confusing for writing geometry manipulation 
code.  And also, isn't the OGC standard SF99 demanding that geometry 
collections always have at least one member geometry?  Or am I missing 
something here?


International Institute for Geo-Information Science and Earth Observation (ITC)
Chamber of Commerce: 410 27 560

E-mail disclaimer
The information in this e-mail, including any attachments, is intended for the addressee only. If you are not the intended recipient, you are hereby notified that any disclosure, copying, distribution or action in relation to the content of this information is strictly prohibited. If you have received this e-mail by mistake, please delete the message and any attachment and inform the sender by return e-mail. ITC accepts no liability for any error or omission in the message content or for damage of any kind that may arise as a result of e-mail transmission.

More information about the postgis-users mailing list