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
