Postgres Pro
Downloads
Home   >   mailing lists

Re: Infinity vs Error for division by zero - Mailing list pgsql-hackers

From Andrew Gierth
Subject Re: Infinity vs Error for division by zero
Date
Msg-id 87lg1ycwbv.fsf@news-spur.riddles.org.uk
Whole thread Raw
In response to Infinity vs Error for division by zero  (Matt Pulver <mpulver@unitytechgroup.com>)
List pgsql-hackers
Tree view 
>>>>> "Matt" == Matt Pulver <mpulver@unitytechgroup.com> writes:

 Matt> ERROR:  division by zero

 Matt> Question: If Infinity and NaN are supported, then why throw an
 Matt> exception here, instead of returning Infinity?

Spec says so:

  4) The dyadic arithmetic operators <plus sign>, <minus sign>,
     <asterisk>, and <solidus> (+, -, *, and /, respectively) specify
     addition, subtraction, multiplication, and division, respectively.
     If the value of a divisor is zero, then an exception condition is
     raised: data exception -- division by zero.

-- 
Andrew (irc:RhodiumToad)

pgsql-hackers by date:

Previous
From: Matt Pulver
Date:
Subject: Infinity vs Error for division by zero
Next
From: "David G. Johnston"
Date:
Subject: Re: Infinity vs Error for division by zero