-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1
Hi,
On Wed, 29 Sep 2004, Shridhar Daithankar wrote:
SELECT 512*18014398509481984 AS result;
and the result is:
result ---------------------- -9223372036854775808
It should be 9223372036854775808... This is PostgreSQL 7.4.5 on Fedora Core 2.
[EMAIL PROTECTED]:~$ psql template1
<snip>
template1=# SELECT 512*18014398509481984::numeric(20) AS result; result --------------------- 9223372036854775808 (1 row)
Ok, I got the same result in 7.4.5... But... Why do we have to cast it into numeric? The results from other databases shows that they can perform it without casting...
Anyway, thanks for the tip.
Regards,
- --
Devrim GUNDUZ devrim~gunduz.org devrim.gunduz~linux.org.tr
http://www.tdmsoft.com
http://www.gunduz.org
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.2.1 (GNU/Linux)
iD8DBQFBWniTtl86P3SPfQ4RAt9/AJ0dG8bXaDVgqAvtgIDiEAX7MwU4YACfeR+l c4nhYwft3NvJWhOdHJ90Lm8= =4uVc -----END PGP SIGNATURE-----
---------------------------(end of broadcast)--------------------------- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly