数据仓库服务 GAUSSDB(DWS)-二进制字符串函数和操作符:trim([both] bytes from string)

时间:2024-01-26 16:15:19

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/sqlreference-820-dws/dws_06_0031.html
推荐文章