数智融合计算服务 DATAARTSFABRIC-二进制字符串函数和操作符:overlay(string placing string from int [for int])

时间:2025-06-17 08:50:21

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/devg-fabric/dataartsfabric_sql_04_0202.html
推荐文章