View Single Post

   
  #9 (permalink)  
Old 05-10-2008, 03:05 PM
Tom Lane
 
Posts: n/a
Default Re: pgsql: Have numeric 0 ^ 4.3 return 1, rather than an error, and have 0 ^

Bruce Momjian <bruce@momjian.us> writes:
>> b) If VB is 0 (zero) and VE is negative, then an exception condition is
>> raised: data exception Ñ invalid argument for power function.


> Well, this indicates we shouldn't return "zero raised to a negative
> power is undefined", but rather the power error we are giving now, or
> are you saying we should return the "power" error code but an error
> message mentioning zero?


The spec says what the SQLSTATE code should be. We have always felt
free to word the message text more specifically than that, though.

regards, tom lane

--
Sent via pgsql-committers mailing list (pgsql-committers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-committers

Reply With Quote