From: | Eric B(dot)Ridge <ebr(at)tcdi(dot)com> |
---|---|
To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
Cc: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: division by zero |
Date: | 2003-03-07 19:58:53 |
Message-ID: | 3941E842-50D7-11D7-B70C-0003937E3354@tcdi.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general pgsql-hackers |
On Friday, March 7, 2003, at 02:50 PM, Tom Lane wrote:
> "Eric B.Ridge" <ebr(at)tcdi(dot)com> writes:
>> I admit, I suck at math, but I really thought postgres would ERROR on
>> this:
>
>> foo=# select 1/0;
>
> There's something wrong with your platform, I think. I get an error on
> both HPUX and Red Hat Linux. What platform is this? and what PG
> version?
I'm sorry. I know better.
% uname -a
Darwin foo.local. 6.4 Darwin Kernel Version 6.4: Wed Jan 29 18:50:42
PST 2003; root:xnu/xnu-344.26.obj~1/RELEASE_PPC Power Macintosh powerpc
Which translates to Mac OS X 10.2.4 (6I32)
foo=# select version();
version
------------------------------------------------------------------------
--------------------------
PostgreSQL 7.3.2 on powerpc-apple-darwin6.4, compiled by GCC gcc (GCC)
3.1 20020420 (prerelease)
select 1/0; fails as expected on my x86 Linux box, so yer right, it's
just my little Mac. "I switched because Mac's can divide by zero."
eric
> z=# select 1/0;
> ERROR: floating point exception! The last floating point operation
> either exceeded legal ranges or was a divide by zero
> z=#
>
> regards, tom lane
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2003-03-07 20:05:12 | Re: division by zero |
Previous Message | Tom Lane | 2003-03-07 19:50:15 | Re: division by zero |
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2003-03-07 20:03:03 | Re: I cant find it or I'm just lazy ? |
Previous Message | Tom Lane | 2003-03-07 19:50:15 | Re: division by zero |