Class ConcatWsFunction

  • All Implemented Interfaces:
    SqlFunction

    public final class ConcatWsFunction
    extends SqlScalarFunction
    Concatenate all but the first argument with separators. The first parameter is used as a separator. The function needs at least 2 params. Null behavior: concat_ws(null, ...) returns null. concat_ws(sep, arg1, arg2,..., argN) returns arg1 through argN concatenated with separator 'sep'. Null arguments are ignored. concat_ws(sep, array[strings]) returns elements in the array concatenated with separators.