stats=# select 10000*1000000000, 10000*1000000000::bigint; ?column? | ?column? ------------+---------------- 1316134912 | 10000000000000 (1 row) Shouldn't the first expression throw an error instead of doing whatever it's actually doing? This is the sort of thing I like to bash mysql about... Version 7.4.2 if it matters... -- Jim C. Nasby, Database Consultant jim@nasby.net Member: Triangle Fraternity, Sports Car Club of America Give your computer some brain candy! www.distributed.net Team #1828 Windows: "Where do you want to go today?" Linux: "Where do you want to go tomorrow?" FreeBSD: "Are you guys coming, or what?" ---------------------------(end of broadcast)--------------------------- TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org
