Re: [GENERAL] Migrating money column from MS SQL Server to Postgres

Поиск
Список
Период
Сортировка
От Igal @ Lucee.org
Тема Re: [GENERAL] Migrating money column from MS SQL Server to Postgres
Дата
Msg-id fdf92d62-c165-e6f3-9a22-dbb562b5afd4@lucee.org
обсуждение исходный текст
Ответ на Re: [GENERAL] Migrating money column from MS SQL Server to Postgres  (Allan Kamau <kamauallan@gmail.com>)
Ответы Re: [GENERAL] Migrating money column from MS SQL Server to Postgres  ("Igal @ Lucee.org" <igal@lucee.org>)
Список 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 по дате отправления:

Предыдущее
От: Allan Kamau
Дата:
Сообщение: Re: [GENERAL] Migrating money column from MS SQL Server to Postgres
Следующее
От: "Igal @ Lucee.org"
Дата:
Сообщение: Re: [GENERAL] Migrating money column from MS SQL Server to Postgres