Thread: pgsql: Allow casting between bytea and integer types.
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(-)