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 по дате отправления: