[postgis-users] GeomUnion returns a Null geometry

Arnaud Lesauvage thewild at freesurf.fr
Mon Oct 2 01:05:23 PDT 2006


Markus Schaber wrote:
> HI, Arnaud,
> 
> Arnaud Lesauvage wrote:
> 
>> I join to this message a csv of the problematic dataset.
> 
>> gid;geom
>> 100013;MULTIPOLYGON((([...])))
>> ;
>> ;
>> ;
>> ;
> 
> Sounds like only the first of your five polygons was output.
> 
> Could the others be null?
> 
> Could you give us the results of
> 
>   SELECT gid;geom is null;isvalid(geom) FROM yourtable;
> 


Hi Markus,
I slept on this and rewrote my queries from scratch. They now work 
fine !
I believe that I had some null geometries in the union before and 
not anymore.
Does a geomunion return null whenever one of the geometries is null ?

Thanks a lot for suggestiong this !

Arnaud



More information about the postgis-users mailing list