Bug report #9998

Error Null values in PostGIS

Added by Samuel Fernando Mesa Giraldo over 6 years ago. Updated over 6 years ago.

Affected QGIS version:2.2.0 Regression?:No
Operating System:Linux Easy fix?:No
Pull Request or Patch supplied:No Resolution:
Crashes QGIS or corrupts data:No Copied to github as #:18489


In PostGIS (2.1) the Null values are displayed correctly in the attribute table. However, when displaying the label is treated as a value of 0, similarly when I perform an operation interpolation (IDW algorithm from the raster menu), where this result should ignore null values stations.

Attached a screenshot trying to explain the results of interpolation and labeled, possibly wrong with null values.


Related issues

Related to QGIS Application - Bug report #10151: expression-based label regression, wrongly displaying NUL... Closed 2014-05-01

Associated revisions

Revision e497a5c0
Added by Jürgen Fischer over 6 years ago

labeling: consider configure representation for NULL values (fixes #9998)

Revision 3d916633
Added by Jürgen Fischer over 6 years ago

labeling: 'show' empty string instead of configured representation for NULL (party reverts e497a5c; refs #9998; fixes #10151)


#1 Updated by Paolo Cavallini over 6 years ago

  • Priority changed from Normal to High

#2 Updated by Jürgen Fischer over 6 years ago

  • Assignee deleted (Jürgen Fischer)
  • Category deleted (Data Provider/PostGIS)

Not related to the PostGIS provider. Any QVariant( QVariant::Double ).toString() evaluates to 0.

#3 Updated by Jürgen Fischer over 6 years ago

  • Status changed from Open to Closed

Also available in: Atom PDF