数智融合计算服务 DATAARTSFABRIC-二进制字符串函数和操作符:trim([both] bytes from string)
时间:2025-06-17 08:50:21
trim([both] bytes from string)
描述:从string的开头和结尾删除只包含bytes中字节的最长字符串。
返回值类型:bytea
示例:
1 2 3 4 5 |
SELECT trim(E'\\000'::bytea from E'\\000Tom\\000'::bytea) AS RESULT; result ---------- \x546f6d (1 row) |
support.huaweicloud.com/devg-fabric/dataartsfabric_sql_04_0202.html