Re: [BUGS] BUG #14894: Data Type Money
| От | John R Pierce |
|---|---|
| Тема | Re: [BUGS] BUG #14894: Data Type Money |
| Дата | |
| Msg-id | e8e0dab6-97df-7bfb-7bbc-f1f926e013f2@hogranch.com обсуждение исходный текст |
| Ответ на | [BUGS] BUG #14894: Data Type Money (tfredy02@gmail.com) |
| Ответы |
Re: [BUGS] BUG #14894: Data Type Money
|
| Список | pgsql-bugs |
On 11/9/2017 11:48 AM, tfredy02@gmail.com wrote: > Hello. > I'm Migrate from sql server but have a problem with the data type Money. > I Was investigate and found the same data so much in sql server as > postgresql but has a difference is the point decimal too investigate data > type numeric(19,4) might use this, but i need use money with four decimal, > Thank. > I hope you can help me. > > Sql Server -922337203685477.5808 to 922,337,203,685,477.5807 > > Postgresql -92233720368547758.08 to +92233720368547758.07 use NUMERIC(19,4)... the MONEY type really should be deprecated -- john r pierce, recycling bits in santa cruz -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs
В списке pgsql-bugs по дате отправления: