pgsql: Allow casting between bytea and integer types.

Поиск
Список
Период
Сортировка
От Dean Rasheed
Тема pgsql: Allow casting between bytea and integer types.
Дата
Msg-id E1tqU6u-001EVK-2A@gemulon.postgresql.org
обсуждение исходный текст
Список pgsql-committers
Allow casting between bytea and integer types.

This allows smallint, integer, and bigint values to be cast to and
from bytea. The bytea value is the two's complement representation of
the integer, with the most significant byte first. For example:

  1234::bytea -> \x000004d2
  (-1234)::bytea -> \xfffffb2e

Author: Aleksander Alekseev <aleksander@timescale.com>
Reviewed-by: Joel Jacobson <joel@compiler.org>
Reviewed-by: Yugo Nagata <nagata@sraoss.co.jp>
Reviewed-by: Peter Eisentraut <peter@eisentraut.org>
Reviewed-by: Michael Paquier <michael@paquier.xyz>
Reviewed-by: Dean Rasheed <dean.a.rasheed@gmail.com>
Discussion: https://postgr.es/m/CAJ7c6TPtOp6%2BkFX5QX3fH1SVr7v65uHr-7yEJ%3DGMGQi5uhGtcA%40mail.gmail.com

Branch
------
master

Details
-------
https://git.postgresql.org/pg/commitdiff/6da469badaffec32f8a804181cca279561467378

Modified Files
--------------
doc/src/sgml/func.sgml                   |  17 ++++++
src/backend/utils/adt/varlena.c          |  96 +++++++++++++++++++++++++++++
src/include/catalog/catversion.h         |   2 +-
src/include/catalog/pg_cast.dat          |  14 +++++
src/include/catalog/pg_proc.dat          |  19 ++++++
src/test/regress/expected/opr_sanity.out |   3 +
src/test/regress/expected/strings.out    | 102 +++++++++++++++++++++++++++++++
src/test/regress/sql/strings.sql         |  29 +++++++++
8 files changed, 281 insertions(+), 1 deletion(-)


В списке pgsql-committers по дате отправления: