[postgis-users] multipoint geometry >> multiple resultset

[Christo Du Preez]

That is fantastic! Thanx very much.

Markus Schaber wrote:
> Hi, Christo,
>
> Christo Du Preez wrote:
>
>   
>> Is there a way to return multiple records querying a single record with
>> a multipoint geometry? In other words, I'd like to return a row for each
>> point in the multipoint geometry.
>>     
>
> Yes, there is. Try something like:
>
> SELECT GeometryN(the_geom,generate_series(1,numGeometries(the_geom)))
> FROM table;
>
> HTH,
> Markus
>   

-- 
Kind Regards,
Christo Du Preez

Senior Software Engineer
Mecola IT
http://www.mecola.com
+27 [0]83 326 8087