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

-- | Dr. Stefan Manegold | mailto:Stefan.Manegold@cwi.nl | | CWI, P.O.Box 94079 | http://www.cwi.nl/~manegold/ | | 1090 GB Amsterdam | Tel.: +31 (20) 592-4212 | | The Netherlands | Fax : +31 (20) 592-4199 |