Skip site navigation (1)
Skip section navigation (2)
Peripheral Links
Re: pgsql: Have numeric 0 ^ 4.3 return 1, rather than an error, and have 0 ^
Tom Lane wrote: > 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. OK, error wording updated, attached, and applied. -- Bruce Momjian <bruce(at)momjian(dot)us> http://momjian.us EnterpriseDB http://enterprisedb.com + If your life is a hard drive, Christ can be your backup. +
Attachment: /rtmp/diff
Description: text/x-diff (2.9 KB)
Description: text/x-diff (2.9 KB)
In response to
- Re: pgsql: Have numeric 0 ^ 4.3 return 1, rather than an error, and have 0 ^ at 2008-05-09 15:57:42 from Tom Lane
pgsql-committers by date
Next: From: User Doj Date: 2008-05-09 22:04:08 Subject: pg-toolbox - pg-toolbox: Imported Sources Previous: From: Bruce Momjian Date: 2008-05-09 21:31:23 Subject: pgsql: Adjust power() error messages to be more descriptive.