Bruce Momjian <bruce(at)momjian(dot)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

In response to

• Re: pgsql: Have numeric 0 ^ 4.3 return 1, rather than an error, and have 0 ^ at 2008-05-09 15:36:07 from Bruce Momjian

Responses

• Re: pgsql: Have numeric 0 ^ 4.3 return 1, rather than an error, and have 0 ^ at 2008-05-09 15:58:41 from Bruce Momjian
• Re: pgsql: Have numeric 0 ^ 4.3 return 1, rather than an error, and have 0 ^ at 2008-05-09 21:32:26 from Bruce Momjian

pgsql-committers by date

Next:	From: Bruce Momjian	Date: 2008-05-09 15:58:41
	Subject: Re: pgsql: Have numeric 0 ^ 4.3 return 1, rather than an error, and have 0 ^
Previous:	From: Tom Lane	Date: 2008-05-09 15:53:07
	Subject: pgsql: Give a warning if -s switch is used with a non-custom pgbench