search

LI3DS / api-li3ds

LI³DS Rest API
GNU General Public License v3.0
0 stars 3 forks source link

fix point ordering (by time) in sbet materalized views #53

Closed ldgeo closed 7 years ago

elemoine commented 7 years ago

And actually I still see the same problem:

select id, pc_patchmin(tr.points, 'time'), pc_patchmax(tr.points, 'time') from "LANDINS_20170516_075157_PP_view" tr where id in (2303, 2304, 2305);
  id  |   pc_patchmin    |   pc_patchmax    
------+------------------+------------------
 2303 | 1494914841.76194 | 1494914842.25695
 2304 | 1494914842.26195 | 1494914842.75695
 2305 | 1494914842.76195 | 1494914843.25696

There's no continuity.

elemoine commented 7 years ago

My apologies, I was using an older version of fdw-li3ds. It works!

elemoine commented 7 years ago

Ids used to start at 0, they start at 1 now. I guess we can just do ((row_number() over ()) - 1) as id

I added a commit for that.