Re: division by zero

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