diff options
| author | Neil Conway <neilc@samurai.com> | 2004-05-19 04:32:26 +0000 |
|---|---|---|
| committer | Neil Conway <neilc@samurai.com> | 2004-05-19 04:32:26 +0000 |
| commit | 132d09054ee1b6d91514b3f56c4e3f64d348470c (patch) | |
| tree | 3dd97af2c7ac22b33ea66a97a4c73b6254b19e4a /src/backend/utils/adt/numeric.c | |
| parent | f16874c23daa3d565f2d418e6aeab8605ae633cb (diff) | |
| download | postgresql-132d09054ee1b6d91514b3f56c4e3f64d348470c.tar.gz postgresql-132d09054ee1b6d91514b3f56c4e3f64d348470c.zip | |
Minor correction for previous SQLSTATE patch: I changed dsqrt() to emit the
right error code previously, and this patch applies an analogous change
to numeric_sqrt().
Diffstat (limited to 'src/backend/utils/adt/numeric.c')
| -rw-r--r-- | src/backend/utils/adt/numeric.c | 8 |
1 files changed, 6 insertions, 2 deletions
diff --git a/src/backend/utils/adt/numeric.c b/src/backend/utils/adt/numeric.c index 9307ba5e6ec..242c7cf9d35 100644 --- a/src/backend/utils/adt/numeric.c +++ b/src/backend/utils/adt/numeric.c @@ -14,7 +14,7 @@ * Copyright (c) 1998-2003, PostgreSQL Global Development Group * * IDENTIFICATION - * $PostgreSQL: pgsql/src/backend/utils/adt/numeric.c,v 1.75 2004/05/16 23:18:55 neilc Exp $ + * $PostgreSQL: pgsql/src/backend/utils/adt/numeric.c,v 1.76 2004/05/19 04:32:26 neilc Exp $ * *------------------------------------------------------------------------- */ @@ -4210,9 +4210,13 @@ sqrt_var(NumericVar *arg, NumericVar *result, int rscale) return; } + /* + * SQL2003 defines sqrt() in terms of power, so we need to emit + * the right SQLSTATE error code if the operand is negative. + */ if (stat < 0) ereport(ERROR, - (errcode(ERRCODE_FLOATING_POINT_EXCEPTION), + (errcode(ERRCODE_INVALID_ARGUMENT_FOR_POWER_FUNCTION), errmsg("cannot take square root of a negative number"))); init_var(&tmp_arg); |