[Bug]: Postgres money type is inferred as categorial input

[Alexnortung]

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.

[ZoranPandovski]

Thanks for reporting this @Alexnortung . It looks like the issue is in our type_infer library. We will check this. @paxcema Should we transfer this issue to type_infer repo ?