Refer to the following table for rules regarding WIDTH_BUCKET arguments.
If an argument cannot be implicitly converted to an acceptable type, an error is reported. For more information, see Teradata Vantage™ Data Types and Literals, B035-1143.
|Numeric||WIDTH_BUCKET accepts all numeric data types as arguments. The arguments value_expression, lower_bound, and upper_bound are converted to REAL before processing. The partition_count argument is converted to INTEGER before processing.|
|Character||WIDTH_BUCKET accepts character strings that represent numeric values, and converts the character strings to the appropriate numeric type.|
||WIDTH_BUCKET does not accept these types of arguments.|