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.
| Data Type | Rules |
|---|---|
| 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. |
| UDT |
|