String function for lower case?


#1

Hi,
Could somebody tell me if there is an equivalent of the LOWER() function for string arrays?
Thanks.


#2

Hi,
Please find the docs for supported scalar functions, we support upper, lower on strings: https://crate.io/docs/crate/reference/en/1.1/sql/scalar.html#lower-string-returns-string
For an array to lowercase, you might need to look into some custom way to achieve it.
Thanks.