I understand we can insert multiple events with the exact timestamp in TimescaleDB.
Now question is whether the ordering will be preserved to their insert order?
If not, what is the best recommended approach to preserve the order?
For example,
Event 1 (10:00:00)
Event 2 (10:00:00)
Event 3 (10:00:01)
If event 1 and event 2 have the same timestamp, how do we ensure query result will always return event 1 before event 2?
Thank you.