[MonetDB-users] Decimal(p,s)
What is the reason that MonetDB only supports a maximum p value of 18 while for example SQL Server (see link) supports up to 38?
http://www.w3schools.com/SQL/sql_datatypes.asp
On Tue, Jun 15, 2010 at 08:23:38AM -0700, Nozhup wrote:
What is the reason that MonetDB only supports a maximum p value of 18 while for example SQL Server (see link) supports up to 38?
MonetDB uses 64-bit signed integers to implement decimals (at no extra cost compared to integers), and 64-bit signed integers only hold max. 18 digits --- well, actually, 2^63 has 19 digits, but 10^18 < 2^63 < 10^19; hence, max 18 digits (signed).
SQL Server apparently uses a different implementation of decimal.
Stefan
http://www.w3schools.com/SQL/sql_datatypes.asp
View this message in context: http://old.nabble.com/Decimal%28p%2Cs%29-tp28892721p28892721.html Sent from the monetdb-users mailing list archive at Nabble.com.
ThinkGeek and WIRED's GeekDad team up for the Ultimate GeekDad Father's Day Giveaway. ONE MASSIVE PRIZE to the lucky parental unit. See the prize list and enter to win: http://p.sf.net/sfu/thinkgeek-promo _______________________________________________ MonetDB-users mailing list MonetDB-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/monetdb-users
participants (2)
-
Nozhup
-
Stefan Manegold