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