数据仓库服务 GAUSSDB(DWS)-二进制字符串函数和操作符:overlay(string placing string from int [for int])

时间:2024-12-06 15:12:38

overlay(string placing string from int [for int])

描述:替换子串。

返回值类型:bytea

示例:

1
2
3
4
5
SELECT overlay(E'Th\\000omas'::bytea placing E'\\002\\003'::bytea from 2 for 3) AS RESULT;
     result     
----------------
 \x5402036d6173
(1 row)
support.huaweicloud.com/sqlreference-910-dws/dws_06_0031.html
推荐文章