"money" type (postgresql) interpreted as string

[qgib]

Author Name: Loïc BARTOLETTI (@lbartoletti)
Original Redmine Issue: 17632
Affected QGIS version: 3.5(master)
Redmine category:field_calculator

---

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 (Loïc BARTOLETTI)
• virtual_field.png (Loïc BARTOLETTI)

[qgib]

Author Name: Harrissou Santanna (@DelazJ)

---

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

[qgib]

Author Name: Loïc BARTOLETTI (@lbartoletti)

---

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

[qgib]

Author Name: Giovanni Manghi (@gioman)

---

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

[qgib]

Author Name: Giovanni Manghi (@gioman)

---

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

[qgib]

Author Name: Jürgen Fischer (@jef-n)

---

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

---

• status_id was changed from Open to Feedback

[qgib]

Author Name: Loïc BARTOLETTI (@lbartoletti)

---

Confirmed in master

---

• version was changed from 2.18.14 to 3.5(master)
• status_id was changed from Feedback to Open

[Pedro-Murteira]

Still valid on QGIS 3.16.15 and 3.22.2.

[strk]

Use of "money" type is discouraged: https://wiki.postgresql.org/wiki/Don't_Do_This#Don.27t_use_money

That said, what is the desired behavior ? Should it be treated as numeric ?

[strk]

PR GH-57513 threats those money values as numbers, @Pedro-Murteira @lbartoletti would you mind giving it a try ?