Time span estimate in result table

mami-project / pto-postgres

PostgreSQL backend for Path Transparency Observatory and associated utilities

0 stars 1 forks source link

Time span estimate in result table #43

Closed ghost closed 6 years ago

ghost commented 7 years ago

In that table, add two columns “From” and “To” giving a reasonable estimate of the tie spans for the relevant observations. (May not be done by 1 March. May not be doable at all in reasonable time. Reason is that queries of a IF NOT EXISTS... nature may touch an unknown number of rows)

FMNSSun commented 7 years ago

Can't be done. If you aggregate you have no timestamps anyway. What's the use case for this?

mirjak commented 7 years ago

Yes, we need to discuss this further. Maybe just leave the issue open for later. The use case is if you have a query and you want to further refine this for generate a next query, the time would be an interesting piece of meta data.

mirjak commented 7 years ago

Related to #58

ghost commented 6 years ago

WONTFIX