[postgis-users] Re: [UMN_MAPSERVER-USERS] How to show lines between PostGIS data of type POINT

[Markus Schaber]

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