diff options
Diffstat (limited to 'src/backend/utils/adt/int.c')
| -rw-r--r-- | src/backend/utils/adt/int.c | 32 |
1 files changed, 28 insertions, 4 deletions
diff --git a/src/backend/utils/adt/int.c b/src/backend/utils/adt/int.c index 8bd234c11c6..42ddae99ef4 100644 --- a/src/backend/utils/adt/int.c +++ b/src/backend/utils/adt/int.c @@ -146,15 +146,39 @@ int2vectorin(PG_FUNCTION_ARGS) result = (int2vector *) palloc0(Int2VectorSize(FUNC_MAX_ARGS)); - for (n = 0; *intString && n < FUNC_MAX_ARGS; n++) + for (n = 0; n < FUNC_MAX_ARGS; n++) { + long l; + char *endp; + while (*intString && isspace((unsigned char) *intString)) intString++; if (*intString == '\0') break; - result->values[n] = pg_atoi(intString, sizeof(int16), ' '); - while (*intString && !isspace((unsigned char) *intString)) - intString++; + + errno = 0; + l = strtol(intString, &endp, 10); + + if (intString == endp) + ereport(ERROR, + (errcode(ERRCODE_INVALID_TEXT_REPRESENTATION), + errmsg("invalid input syntax for type %s: \"%s\"", + "smallint", intString))); + + if (errno == ERANGE || l < SHRT_MIN || l > SHRT_MAX) + ereport(ERROR, + (errcode(ERRCODE_NUMERIC_VALUE_OUT_OF_RANGE), + errmsg("value \"%s\" is out of range for type %s", intString, + "smallint"))); + + if (*endp && *endp != ' ') + ereport(ERROR, + (errcode(ERRCODE_INVALID_TEXT_REPRESENTATION), + errmsg("invalid input syntax for type %s: \"%s\"", + "integer", intString))); + + result->values[n] = l; + intString = endp; } while (*intString && isspace((unsigned char) *intString)) intString++; |