On Thu, Dec 06, 2007 at 02:12:48PM -0600, Matthew Dennis wrote:
I want to create an aggregate that will give the average velocity (sum of
distance traveled / sum of elapsed time) from position and timestamps.
How do you want to handle noisy data? If you want to handle it in any
reasonable way
I want to create an aggregate that will give the average velocity (sum of
distance traveled / sum of elapsed time) from position and timestamps.
example:
create table data(position integer, pos_time timestamp, trip_id integer);
insert into data values(1, time x, 1);
insert into data values(2,
Matthew Dennis [EMAIL PROTECTED] writes:
So, my question is if I can have PostgreSQL honor order by clauses such as:
select trip_id, avg_vel(position, pos_time)
from (select position, pos_time, trip_id from data order by pos_time)
sorted_data
Would this in fact guarantee that the rows