数智融合计算服务 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