Re: division by zero

On Friday, March 7, 2003, at 02:50  PM, Tom Lane wrote:

> "Eric B.Ridge" <ebr@tcdi.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