I think my problem is quite easy to be solved by the most postgis-users, but i am a bloody beginner: i have a timestamped point-table representing GPS-tracked places of different cars. To distinguish the cars there is a car-id for every point. So, a simplified version is looking like that:
Now, i want to write a query for connecting the places of each car chronologically with lines so that the track of each car can be displayed. The table is sorted chronologically, so it can be worked with the id's instead of the timestamps. How can I solve it? Thank you in advance!