On 2010-03-29, L. Loewe <lloewe(at)hotmail(dot)com> wrote:> Hi all
> SELECT * FROM events, main WHERE main.ti > events.start and> main.ti < events.stop and sensor_id=1;
create index main_ti_sid on main(sensor_id,ti);