Re: pgsql: Have numeric 0 ^ 4.3 return 1, rather than an error, and have 0 ^

Bruce Momjian <bruce@[EMAIL PROTECTED]
> 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@[EMAIL PROTECTED]
)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-committers