Function overlay_for_bytea

Source
pub fn overlay_for_bytea(
    s: &[u8],
    new_sub_str: &[u8],
    start: i32,
    count: i32,
) -> Result<Box<[u8]>>
Expand description

Replaces a range of bytes in a bytea value with another bytea.

statement error not positive
select overlay('\x616263'::bytea placing '\x313233'::bytea from 0);

query T
select overlay('\x616263'::bytea placing '\x313233'::bytea from 10);
----
\x616263313233

query T
select overlay('\x616263646566'::bytea placing '\x313233'::bytea from 4 for 2);
----
\x61626331323366

query T
select overlay('\x616263646566'::bytea placing '\x313233'::bytea from 4);
----
\x616263313233

query T
select overlay('\x616263646566'::bytea placing '\x313233'::bytea from 2 for 4);
----
\x6131323366

query T
select overlay('\x616263646566'::bytea placing '\x313233'::bytea from 2 for 7);
----
\x61313233

query T
select overlay('\x616263646566'::bytea placing '\x313233'::bytea from 4 for 0);
----
\x616263313233646566

query T
select overlay('\x616263646566'::bytea placing '\x313233'::bytea from 4 for -2);
----
\x6162633132336263646566

query T
select overlay('\x616263646566'::bytea placing '\x313233'::bytea from 4 for -1000);
----
\x616263313233616263646566