trim(string text[, characters text])
Advertisements
Let us now check the trim(string,char) function with the following query.
Query
default> select trim('tutorialspoint','t') as trim_char;
Result
The above query will generate the following result.
trim_char ------------------------------- utorialspoin
Here, the char ’t’ is trimmed from ‘tutorialspoint’.
apache_tajo_string_functions.htm
Advertisements