Re: [GENERAL] Migrating money column from MS SQL Server to Postgres - Mailing list pgsql-general

From Igal @ Lucee.org
Subject Re: [GENERAL] Migrating money column from MS SQL Server to Postgres
Date
Msg-id fdf92d62-c165-e6f3-9a22-dbb562b5afd4@lucee.org
Whole thread Raw
In response to Re: [GENERAL] Migrating money column from MS SQL Server to Postgres  (Allan Kamau <kamauallan@gmail.com>)
Responses Re: [GENERAL] Migrating money column from MS SQL Server to Postgres
List pgsql-general
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

pgsql-general by date:

Previous
From: Allan Kamau
Date:
Subject: Re: [GENERAL] Migrating money column from MS SQL Server to Postgres
Next
From: "Igal @ Lucee.org"
Date:
Subject: Re: [GENERAL] Migrating money column from MS SQL Server to Postgres