| From: | "Jim C(dot) Nasby" <jim(at)nasby(dot)net> |
|---|---|
| To: | pgsql-general(at)postgresql(dot)org |
| Subject: | Silent overflow |
| Date: | 2004-04-23 21:23:18 |
| Message-ID: | 20040423212318.GQ41429@nasby.net |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
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(at)nasby(dot)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?"
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Jerry Robertson | 2004-04-23 22:06:12 | Question |
| Previous Message | Anony Mous | 2004-04-23 19:10:49 | Re: FW: Postgres alongside MS SQL Server |