Hi, Nicol, Hi, Stephen, What about: SELECT setsrid(makeline(collect(makepoint(lon, lat))), 4326) FROM table I don't see the need for a subquery at all... Markus -- Markus Schaber | Logical Tracking&Tracing International AG Dipl. Inf. | Software Development GIS Fight against software patents in EU! www.ffii.org www.nosoftwarepatents.org