Thanks Tom, looks like a good example, glad i'm not the only one with this issue. Time to write some test queries.. Cheers, Rob -- View this message in context: http://postgis.17.n6.nabble.com/Extracting-points-from-a-line-tp4999135p4999187.html Sent from the PostGIS - User mailing list archive at Nabble.com.