Re: Migrating money column from MS SQL Server to Postgres

["Igal @ Lucee.org" <igal@xxxxxxxxx>]

On 11/8/2017 5:27 PM, Allan Kamau wrote:

Maybe using NUMERIC without explicitly stating the precision is recommended. This would allow for values with many decimal places to be accepted without truncation. Your field may need to capture very small values such as those in bitcoin trading or some banking fee or interest.

That's a very good idea.  For some reason I thought that I tried that earlier and it didn't work as expected, but I just tested it (again?) and it seems to work well, so that's what I'll do.

Thank you,

Igal Sapir
Lucee Core Developer
Lucee.org