'infinity' PostgreSQL date/time input not showing in QGIS attributes table #24004
Labels
Bug
Either a bug report, or a bug fix. Let's hope for the latter!
Milestone
Author Name: Thomas Williamson (Thomas Williamson)
Original Redmine Issue: 16090
Affected QGIS version: 2.14.10
Redmine category:browser
A PostgreSQL table containing a date-type column is displayed in QGIS via DB Manager plugin. The date-type column contains either proper dates (e.g. '2017-01-01') or 'infinity' values (see date / time inputs in PostgreSQL: http://bit.ly/2iIHUDv).Once the table is displayed in QGIS, the attributes table shows 'NULL' values instead of 'infinity'. Then, it is not possible to display features having 'infinity' value. I tried a rule-based styling and rules such as "date" IS NULL or "date" = NULL or "date" = 'infinity' return 0 selected feature. Same problem with QGIS LTR versions 2.14.6-2 and 2.14.11-1.
The text was updated successfully, but these errors were encountered: