[postgis-users] Re: postgis-users Digest, Vol 65, Issue 14

[Simon Greener]

Kevin,

> This is because you are using PointN(geom, int) to iterate over your
> MultiPoint geometry.  PointN is for selecting the Nth point in a
> LineString.  Try using GeometryN instead.

Silly me, I looked at the MultiPoint as being points when I should have looked at them as geometries!

Works now.

Thank you very much.

regards
Simon
-- 
SpatialDB Advice and Solutions Architecture,
Oracle Database 10g Administrator Certified Associate; Oracle Database 10g SQL Certified Professional
Oracle Spatial, SQL Server, PostGIS, MySQL, ArcSDE, Manifold GIS, Radius Topology and Studio Specialist.
39 Cliff View Drive, Allens Rivulet, 7150, Tasmania, Australia.
Website: www.spatialdbadvisor.com
   Email: simon at spatialdbadvisor.com
   Voice: +613 9016 3910
Mobile: +61 418 396391
Skype: sggreener
Longitude: 147.20515 (147° 12' 18" E)
Latitude: -43.01530 (43° 00' 55" S)
NAC:W80CK 7SWP3