Allow casting between bytea and integer types.
Dean Rasheed <dean.a.rasheed@gmail.com>
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
Files
| Path | Change | +/− |
|---|---|---|
| doc/src/sgml/func.sgml | modified | +17 −0 |
| src/backend/utils/adt/varlena.c | modified | +96 −0 |
| src/include/catalog/catversion.h | modified | +1 −1 |
| src/include/catalog/pg_cast.dat | modified | +14 −0 |
| src/include/catalog/pg_proc.dat | modified | +19 −0 |
| src/test/regress/expected/opr_sanity.out | modified | +3 −0 |
| src/test/regress/expected/strings.out | modified | +102 −0 |
| src/test/regress/sql/strings.sql | modified | +29 −0 |
Documentation touched
Discussion
- [PATCH] Add get_bytes() and set_bytes() functions 34 messages · 2024-08-14 → 2025-03-07