qgib
commented
7 years ago Author Name: Nyall Dawson (@nyalldawson)
QGIS 3.0 has classes for ranges such as QgsDoubleRange, QgsIntRange, QgsDateTimeRange and QgsDateRange (also it's easy to add support for other range types)
This would be a matter of translating the Postgres range types across to these native QGIS ranges. It should be a lossless conversion (since I designed qgis ranges based off postgres ranges!).
The trickier bit is what you'd actually DO with these ranges when you have them in QGIS. For this we'd need to add expression functions which can extract parts of the range and perform tests like range intersects, contains, etc...
Anyway, better to keep it as a single field and use the native qgis range types to avoid confusion and to better follow the actual database structure.
Author Name: Anita Graser (@anitagraser) Original Redmine Issue: 16708
Redmine category:data_provider/postgis
Range types are data types representing a range of values of some element type. For instance, ranges of timestamp might be used to represent the ranges of time that a meeting room is reserved.
https://www.postgresql.org/docs/current/static/rangetypes.html
Currently, these columns are ignored and cannot be viewed.
To make them usable in QGIS, it might be best to split the range into two columns (start and end).