Thanks for this compressive answer! I appreciate it.
I tested doing first(device_uuid,(measuring_result,time))), the view does create without a problem, I can also refresh it’s data. But when I try select anything from it I get an error: ERROR: input of anonymous composite types is not implemented. any idea why that happens? Probably something not yet implemented, I am using TimescaleDB 2.6.0 with Postgress 14. Although I am not that worried about having to be picked the wrong time when they are more rows with min/max value. This should be pretty rare in my use case.
The filtering by device_uuid was only for testing so I don’t get huge outputs from a query, since it didn’t work I didn’t bother removing it.
I have already looked into toolkit, looks pretty great especially that I am big fan of Rust! Do you have a roadmap/plans for adding Windows target to it? Unfortunately in some deployments I am bound to it…