1 Answer
- Newest
- Most votes
- Most comments
1
From your error seems as the LENGTH('testing') returns a BigInt, while REPEAT expects an Int as second parameter.
You can try to CAST(LENGTH('testing') AS INTEGER)
https://docs.aws.amazon.com/redshift/latest/dg/r_CAST_function.html
Relevant content
- asked a year ago
- asked a year ago
- AWS OFFICIALUpdated 2 months ago
- AWS OFFICIALUpdated 2 years ago
- AWS OFFICIALUpdated a year ago
- AWS OFFICIALUpdated 2 years ago