PostgreSQL money type field not handled properly

1

If I want to report on revenue, which is a money field type, Metabase runs incorrect queries which result in errors.

For example, if I want to filter where money is greater than a certain amount, I get this error: “ERROR: operator does not exist: money > integer”

If I want to get a sum of the revenue, I get this error: “Bad value for type double”

It seems that Metabase won’t work with the money data type at all and there is also no way to cast the values. Is there a solution for this?

1 Like
2

I just tried in 0.28 and get the same error.
Only solution I can think of is to create a view that casts the money to a numeric.
Looks like a limitation of the Postgresql driver as it works fine with MS SQL.