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
Дата	9 ноября 2017 г. 05:25:24
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
Список	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 по дате отправления:

Вход в личный кабинет

Восстановление пароля

Подтверждение аккаунта

Изменение пароля

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