diff options
| author | Bruce Momjian <bruce@momjian.us> | 2008-05-09 21:31:23 +0000 |
|---|---|---|
| committer | Bruce Momjian <bruce@momjian.us> | 2008-05-09 21:31:23 +0000 |
| commit | f8df836ae396be28a6c9e4f79a6adf3e5c0187b5 (patch) | |
| tree | 3b912e87daadfad534680b4eaa422b3bc555fcc3 /src/backend/utils/adt/float.c | |
| parent | 31590406278bfbee18bf221f3d7d775be5b8bca6 (diff) | |
| download | postgresql-f8df836ae396be28a6c9e4f79a6adf3e5c0187b5.tar.gz postgresql-f8df836ae396be28a6c9e4f79a6adf3e5c0187b5.zip | |
Adjust power() error messages to be more descriptive.
Diffstat (limited to 'src/backend/utils/adt/float.c')
| -rw-r--r-- | src/backend/utils/adt/float.c | 11 |
1 files changed, 7 insertions, 4 deletions
diff --git a/src/backend/utils/adt/float.c b/src/backend/utils/adt/float.c index 3df08cc6a34..d19f9edb827 100644 --- a/src/backend/utils/adt/float.c +++ b/src/backend/utils/adt/float.c @@ -8,7 +8,7 @@ * * * IDENTIFICATION - * $PostgreSQL: pgsql/src/backend/utils/adt/float.c,v 1.156 2008/05/09 15:36:06 momjian Exp $ + * $PostgreSQL: pgsql/src/backend/utils/adt/float.c,v 1.157 2008/05/09 21:31:23 momjian Exp $ * *------------------------------------------------------------------------- */ @@ -1334,11 +1334,14 @@ dpow(PG_FUNCTION_ARGS) * certain error conditions. Specifically, we don't return a divide-by-zero * error code for 0 ^ -1. */ - if ((arg1 == 0 && arg2 < 0) || - (arg1 < 0 && floor(arg2) != arg2)) + if (arg1 == 0 && arg2 < 0) ereport(ERROR, (errcode(ERRCODE_INVALID_ARGUMENT_FOR_POWER_FUNCTION), - errmsg("invalid argument for power function"))); + errmsg("zero raised to a negative power is undefined"))); + if (arg1 < 0 && floor(arg2) != arg2) + ereport(ERROR, + (errcode(ERRCODE_INVALID_ARGUMENT_FOR_POWER_FUNCTION), + errmsg("a negative number raised to a non-integer power yields a complex result"))); /* * pow() sets errno only on some platforms, depending on whether it |