View Single Post

   
  #10 (permalink)  
Old 05-10-2008, 03:05 PM
Bruce Momjian
 
Posts: n/a
Default Re: pgsql: Have numeric 0 ^ 4.3 return 1, ratherthan an error, and have 0 ^

Tom Lane wrote:
> 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.


OK, I will work on it then.

--
Bruce Momjian <bruce@momjian.us> http://momjian.us
EnterpriseDB http://enterprisedb.com

+ If your life is a hard drive, Christ can be your backup. +

--
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