Bug report #17632

"money" type (postgresql) interpreted as string

Added by Loïc BARTOLETTI almost 7 years ago. Updated almost 6 years ago.

Status:Open
Priority:Normal
Assignee:-
Category:Field calculator
Affected QGIS version:3.5(master) Regression?:No
Operating System: Easy fix?:No
Pull Request or Patch supplied:No Resolution:
Crashes QGIS or corrupts data:No Copied to github as #:25529

Description

In composer and virtual field, I have this error.

Try to add numeric fields and return NULL (decimal field for virtual field) or a string concatenation into composer.

composer.png (1.55 KB) Loïc BARTOLETTI, 2017-12-05 03:31 PM

virtual_field.png (4.18 KB) Loïc BARTOLETTI, 2017-12-05 03:31 PM

History

#1 Updated by Harrissou Santanna almost 7 years ago

Could it have to do with the € suffix in the fields ?

#2 Updated by Loïc BARTOLETTI almost 7 years ago

Sorry it's Money type from postgis and not a numeric field.

#3 Updated by Giovanni Manghi almost 7 years ago

  • Subject changed from Addition of numeric type (postgis) interpreted as string to Addition of "money" type (postgis) interpreted as string

#4 Updated by Giovanni Manghi almost 7 years ago

  • Subject changed from Addition of "money" type (postgis) interpreted as string to "money" type (postgresql) interpreted as string

#5 Updated by Jürgen Fischer almost 6 years ago

  • Status changed from Open to Feedback

Please test with QGIS 3.4 - QGIS 2.18 reached it's end of life.

#6 Updated by Loïc BARTOLETTI almost 6 years ago

  • Affected QGIS version changed from 2.18.14 to 3.5(master)
  • Status changed from Feedback to Open

Confirmed in master

Also available in: Atom PDF