stats=# select 10000*1000000000, 10000*1000000000::bigint; ?column? | ?column? ------------+---------------- 1316134912 | 10000000000000 (1 row)
Shouldn't the first expression throw an error instead of rolling over silently? Version 7.4.2 if it matters... -- Jim C. Nasby, Database Consultant [EMAIL PROTECTED] 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 6: Have you searched our list archives? http://archives.postgresql.org