On Mon, 21 Sept 2026 at 14:23, Sehrope Sarkuni <sehrope@jackdb.com> wrote:
>
> Hi hackers,
>
> 0002 adds a four-argument set_byte():
>
> set_byte(bytes bytea, n integer, newvalue integer, count integer)
>
> setting count consecutive bytes from byte n to newvalue:
>
> SELECT set_byte('\x0000000000'::bytea, 1, 255, 3);
> => \x00ffffff00
>
> Today this needs nested set_byte() calls, each copying the whole
> value. The new form does one copy and one memset().
Doesn't the `overlay(bytea, ...)` function already provide the feature
you're looking for (possibly combined with repeat() for ease of use)?
See https://www.postgresql.org/docs/current/functions-binarystring.html#id-1.5.8.11.5.2.2.6.1.1.1
and/or the ISO SQL spec for its specification.
Kind regards,
Matthias van de Meent
Databricks (https://www.databricks.com)
