[postgis-users] MakeLine for geography coordinates

[Sandro Santilli]

On Tue, Apr 05, 2011 at 04:46:09PM -0400, Jochen Albrecht wrote:
> Hmm, the casting worked Sandro. No error message and a column type
> geography. Unfortunately, it is not recognized as a valid geometry that can
> be displayed in qgis or udig, where the result shows up as a plain table.

Re-read ?

> > 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