Hello,
I’ve had decimal precision crop up quite a few times as a problem, where the client would prefer more or less precision than 8 decimal places.
While we can simulate less precision, more precision cannot be done without saving on strings (which is inefficient). After having a look at the database tables, decimal columns use numeric types in postgress which can go to 16383 decimal point precision. Altering the table locally also works fine.
Could we have a choice on decimal precision, and potentially precision before the decimal point?
This would be awesome. In addition, it would be great if the default client and default database settings would be equal on decimal precission. At the moment they are not.