[postgis-users] linestring using geography columns

[tasneem dewaswala]

Hello,

I have 3 columns in my table, with data as

Latitude               Longitude          Utc_time

56.6474065        12.8533945         132733
56.647401          12.8534145         132733
56.6473953333   12.8534343333    132733
56.6473893333   12.8534556667    132733
56.6473006667   12.8537761667    132737
56.647293          12.8538066667    132737
56.6472853333   12.8538373333    132737

I want to  create a Geography linestring/multiline column of
latitude/longitude values where time is same
for eg. time of first 4 rows is same, hence a line should be created
between 1st row and 4th row.

any idea how can i do this, and a proper syntax is requested , since i am
very new in creating a spatial table.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20121224/43187ee0/attachment.html>