pgsql: Allow explicit casting between bytea and uuid.
| От | Masahiko Sawada |
|---|---|
| Тема | pgsql: Allow explicit casting between bytea and uuid. |
| Дата | |
| Msg-id | E1w3KLh-000Xjy-0E@gemulon.postgresql.org обсуждение исходный текст |
| Список | pgsql-committers |
Allow explicit casting between bytea and uuid. This enables the use of functions such as encode() and decode() with UUID values, allowing them to be converted to and from alternative formats like base64 or hex. The cast maps the 16-byte internal representation of a UUID directly to a bytea datum. This is more efficient than going through a text forepresentation. Bump catalog version. Author: Dagfinn Ilmari Mannsåker <ilmari@ilmari.org> Co-authored-by: Aleksander Alekseev <aleksander@tigerdata.com> Reviewed-by: Masahiko Sawada <sawada.mshk@gmail.com> Reviewed-by: Andrey Borodin <x4mmm@yandex-team.ru> Reviewed-by: Jelte Fennema-Nio <postgres@jeltef.nl> Discussion: https://postgr.es/m/CAJ7c6TOramr1UTLcyB128LWMqita1Y7%3Darq3KHaU%3Dqikf5yKOQ%40mail.gmail.com Branch ------ master Details ------- https://git.postgresql.org/pg/commitdiff/ba21f5bf8aff277aa1659a51d26109e0914df182 Modified Files -------------- doc/src/sgml/datatype.sgml | 11 +++++++++++ src/backend/utils/adt/bytea.c | 27 +++++++++++++++++++++++++++ src/include/catalog/catversion.h | 2 +- src/include/catalog/pg_cast.dat | 6 ++++++ src/include/catalog/pg_proc.dat | 7 +++++++ src/test/regress/expected/uuid.out | 22 ++++++++++++++++++++++ src/test/regress/sql/uuid.sql | 5 +++++ 7 files changed, 79 insertions(+), 1 deletion(-)
В списке pgsql-committers по дате отправления: