Re: [PATCH] Refactor bytea_sortsupport(), take two

Aleksander Alekseev <aleksander@tigerdata.com>

From: Aleksander Alekseev <aleksander@tigerdata.com>
To: PostgreSQL Hackers <pgsql-hackers@lists.postgresql.org>
Cc: John Naylor <johncnaylorls@gmail.com>
Date: 2025-11-27T12:45:15Z
Lists: pgsql-hackers

Commits

Same data as JSON: GET /api/v1/messages/:b64id/commits the thread's linked commits as JSON, with link sources. API reference →
  1. Separate out bytea sort support from varlena.c

Attachments

Hi John,

> How about this:
>
> "Short byteas will have terminating NUL bytes in the abbreviated
> datum. Abbreviated comparison need not  make a distinction between
> thse NUL bytes, and NUL bytes representing actual NULs in the
> authoritative representation." [...]
>
> After that, the rest seems to flow better at a quick glance.

Yes, it is much better now, thanks! Previously the comment was
reasoning about NUL bytes as if normally bytea can't have them which
IMO was confusing.


--
Best regards,
Aleksander Alekseev