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@mecon.gov.ar]
> Sent: Friday, March 07, 2003 3:09 PM
> To: Tom Lane
> Cc: Eric B. Ridge; pgsql-general@postgresql.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@candle.pha.pa.us               |  (610) 359-1001
  +  If your life is a hard drive,     |  13 Roberts Road
  +  Christ can be your backup.        |  Newtown Square, Pennsylvania 19073