Re: Migrating money column from MS SQL Server to Postgres

From: "Igal (at) Lucee(dot)org" <igal(at)lucee(dot)org>
To: Allan Kamau <kamauallan(at)gmail(dot)com>
Cc: Postgres General Postgres General <pgsql-general(at)postgresql(dot)org>
Subject: Re: Migrating money column from MS SQL Server to Postgres
Date: 2017-11-09 02:25:24
Message-ID: fdf92d62-c165-e6f3-9a22-dbb562b5afd4@lucee.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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 <http://lucee.org/>

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Igal @ Lucee.org 2017-11-09 06:58:04 Re: Migrating money column from MS SQL Server to Postgres
Previous Message Allan Kamau 2017-11-09 01:27:17 Re: Migrating money column from MS SQL Server to Postgres