Feature request #16708

Support Postgres Range Types

Added by Anita Graser over 3 years ago. Updated about 3 years ago.

Status:Open
Priority:Normal
Assignee:-
Category:Data Provider/PostGIS
Pull Request or Patch supplied:No Resolution:
Easy fix?:No Copied to github as #:24607

Description

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).

History

#1 Updated by Nyall Dawson over 3 years ago

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.

#2 Updated by Jürgen Fischer about 3 years ago

  • Assignee deleted (Jürgen Fischer)

Also available in: Atom PDF