MonetDB type system

From MonetDB
Revision as of 18:10, 6 October 2015 by Stefan Manegold (talk | contribs) (Created page with "{| class="wikitable" style="text-align: center;" |+ MonetDB type system |- ! SQL !! MAL !! C !! width <br> [byte] ([bit]) !! signed? !! range <br> ("raw")...")
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to navigationJump to search
MonetDB type system
SQL MAL C width
[byte] ([bit])
signed? range
("raw")
NIL
value
range
(non-NIL)
format string format cast availability C example semantics
TINYINT :bte bte 1 (8) yes [-128:127] -128 [-127:127] "%hhd" always bte x = 0; printf("%hhd", x); 1-byte (8-bit) signed integer
SMALLINT :sht sht 2 (16) yes [-65536:65535] -65536 [-65535:65535] "%hd" always sht x = 0; printf( "%hd", x); 2-byte (16-bit) signed integer
INT / INTEGER :int int 4 (32) yes [-2147483648:2147483647] -2147483647 [-2147483647:2147483647] "%d" always int x = 0; printf( "%d", x); 4-byte (32-bit) signed integer
BIGINT :lng lng 8 (64) yes [-9223372036854775808:9223372036854775807] -9223372036854775808 [-9223372036854775807:9223372036854775807] LLFMT always lng x = 0; printf(LLFMT , x); 8-byte (64-bit) signed integer