Questions tagged [range-types]
The range-types tag has no usage guidance.
3
questions with no upvoted or accepted answers
1
vote
0
answers
174
views
Returning overlapping rows with same state based on Id
I have a table with internal_id, states, start time and end time. I am trying to overlay the recent state to the previous states and return the value.
I have a simple working example here which works ...
- 11
0
votes
0
answers
40
views
DB scheme for the home exchange site: store date ranges or individual days for availability
I am creating a db schema for a home exchange site.
Host can set his home as exposed for exchange on certain dates. Guest must be able to view available dates.
If exposed date is free (not reserved ...
- 101
0
votes
1
answer
26
views
Select data in steps and ranges
I have the following GPS data. I'm trying to get trips made by the user based on the engine status, and ordered by date where engine=1 is a engine start and engine=2 is a engine off event, so every ...
- 101