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

Markus Schaber schabi at logix-tt.com
Fri Dec 16 06:48:35 PST 2005


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



More information about the postgis-users mailing list