Commit132d090

Neil Conway

committed

Minor correction for previous SQLSTATE patch: I changed dsqrt() to emit the

right error code previously, and this patch applies an analogous changeto numeric_sqrt().

1 parentf16874c commit132d090Copy full SHA for 132d090

File tree

-2

lines changed

-2

lines changed

Lines changed: 6 additions & 2 deletions

Original file line number	Diff line number	Diff line change
`@@ -14,7 +14,7 @@`
`14`	`14`	`* Copyright (c) 1998-2003, PostgreSQL Global Development Group`
`15`	`15`	`*`
`16`	`16`	`* IDENTIFICATION`
`17`		`- * $PostgreSQL: pgsql/src/backend/utils/adt/numeric.c,v 1.75 2004/05/16 23:18:55 neilc Exp $`
	`17`	`+ * $PostgreSQL: pgsql/src/backend/utils/adt/numeric.c,v 1.76 2004/05/19 04:32:26 neilc Exp $`
`18`	`18`	`*`
`19`	`19`	`*-------------------------------------------------------------------------`
`20`	`20`	`*/`
`@@ -4210,9 +4210,13 @@ sqrt_var(NumericVar arg, NumericVar result, int rscale)`
`4210`	`4210`	`return;`
`4211`	`4211`	`}`
`4212`	`4212`
	`4213`	`+/*`
	`4214`	`+ * SQL2003 defines sqrt() in terms of power, so we need to emit`
	`4215`	`+ * the right SQLSTATE error code if the operand is negative.`
	`4216`	`+ */`
`4213`	`4217`	`if (stat<0)`
`4214`	`4218`	`ereport(ERROR,`
`4215`		`-(errcode(ERRCODE_FLOATING_POINT_EXCEPTION),`
	`4219`	`+(errcode(ERRCODE_INVALID_ARGUMENT_FOR_POWER_FUNCTION),`
`4216`	`4220`	`errmsg("cannot take square root of a negative number")));`
`4217`	`4221`
`4218`	`4222`	`init_var(&tmp_arg);`

Comments

(0)