Re: division by zero

Error on BSD/OS too. I should have checked that.

---------------------------------------------------------------------------

Pam Wampler wrote:
> mcs=# select 1/0;
> ERROR: floating point exception! The last floating point operation either
> exceeded legal ranges or was a divide by zero
> mcs=# select version();
> version
> ---------------------------------------------------------------------
> PostgreSQL 7.2.1 on i386-portbld-freebsd4.5, compiled by GCC 2.95.3
> (1 row)
>
>
>
> -----Original Message-----
> From: Fernando Schapachnik [mailto:fernando(at)mecon(dot)gov(dot)ar]
> Sent: Friday, March 07, 2003 3:09 PM
> To: Tom Lane
> Cc: Eric B. Ridge; pgsql-general(at)postgresql(dot)org
> Subject: Re: [GENERAL] division by zero
>
>
> En un mensaje anterior, Tom Lane escribi?:
> > Can anyone confirm whether the error shows up on other BSD-derived
> > platforms?
>
>
> FreeBSD 4.7-RELEASE-p7
>
> db=# SELECT version();
> version
> ---------------------------------------------------------------------
> PostgreSQL 7.3.2 on i386-portbld-freebsd4.7, compiled by GCC 2.95.4
> (1 row)
>
> db=# SELECT 1/0;
> ERROR: floating point exception! The last floating point operation either
> exceeded legal ranges or was a divide by zero
>
> Regards.
>
> ---------------------------(end of broadcast)---------------------------
> TIP 5: Have you checked our extensive FAQ?
>
> http://www.postgresql.org/docs/faqs/FAQ.html
>
> ---------------------------(end of broadcast)---------------------------
> TIP 4: Don't 'kill -9' the postmaster
>

--
Bruce Momjian | http://candle.pha.pa.us
pgman(at)candle(dot)pha(dot)pa(dot)us | (610) 359-1001
+ If your life is a hard drive, | 13 Roberts Road
+ Christ can be your backup. | Newtown Square, Pennsylvania 19073