type_infer
type_infer copied to clipboard
[Bug]: Postgres money type is inferred as categorial input
Short description of current behavior
I am using a postgres database with a money column that has several different values. But mindsdb (or lightwood) infers it as categorial input.
Video or screenshots
When using the sdk I get the following data:
Expected behavior
I would expect the money column to be inferred as a number column, since in postgres it is also a numeric value and is defenitely not a categorial value.
How to reproduce the error
- Use a posgres database
- create a table with a money column
- add several rows with different values
- create a model for it in mindsdb and see that it is inferred as categorial input
Anything else?
I think part of the problem is that postgres formats the money column output.