[postgis-users] MakeLine for geography coordinates

[Sandro Santilli]

On Mon, Apr 04, 2011 at 08:28:25AM -0400, Jochen Albrecht wrote:
>
> Could you please just edit this snippet?
[..]
>   ST_MakeLine(loc) AS line
[..]
> loc is of type geography.

To get a geometry line:

 ST_MakeLine(loc::geometry) as line

To get a geography line:

 ST_MakeLine(loc::geometry)::geography as line

--strk; 

  ()   Free GIS & Flash consultant/developer
  /\   http://strk.keybit.net/services.html