doc: Clarify collation requirements for base32hex sortability. While fixing the base32hex UUID sortability test in commit 89210037a0a, it turned out that the expected lexicographical order is only maintained under the C collation (or an equivalent byte-wise collation). Natural language collations may employ different rules, breaking the sortability.
This commit updates the documentation to explicitly state that base32hex is "byte-wise sortable", ensuring users do not fall into the trap of using natural language collations when querying their encoded data. Co-Authored-by: Andrey Borodin <[email protected]> Discussion: https://postgr.es/m/cad21aoawx1d6basguqxm0mzpxpwb07kgaoaaahjnhhenbdy...@mail.gmail.com Branch ------ master Details ------- https://git.postgresql.org/pg/commitdiff/e752a2ccc98f324e7013cc4eabc1998d5a1020d0 Modified Files -------------- doc/src/sgml/func/func-binarystring.sgml | 14 +++++++++++--- 1 file changed, 11 insertions(+), 3 deletions(-)
