I have a PostGIS table of GPS positions for every five seconds:
2011-01-01 00:00:05, POINT(x1,y1) 2011-01-01 00:00:10, POINT(x2,y2) 2011-01-01 00:00:15, POINT(x3,y3) ...
I'm looking for a query that will return values (timestamp and point) for every second. It's ok to assume that points are connected by a straight line.
I'm specifically looking for a way to do this inside the database and not by writing some external script.