On 23rd of August 2023, Nathan Bossart committed patch:
Add to_bin() and to_oct().
This commit introduces functions for converting numbers to their
equivalent binary and octal representations. Also, the base
conversion code for these functions and to_hex() has been moved to
a common helper function.
Co-authored-by: Eric Radman
Reviewed-by: Ian Barwick, Dag Lem, Vignesh C, Tom Lane, Peter Eisentraut, Kirk Wolak, Vik Fearing, John Naylor, Dean Rasheed
Continue reading Waiting for PostgreSQL 17 – Add to_bin() and to_oct().
On 14th of December 2022, Peter Eisentraut committed patch:
Non-decimal integer literals
Add support for hexadecimal, octal, and binary integer literals:
per SQL:202x draft.
This adds support in the lexer as well as in the integer type input
Reviewed-by: John Naylor <firstname.lastname@example.org>
Reviewed-by: Zhihong Yu <email@example.com>
Reviewed-by: David Rowley <firstname.lastname@example.org>
Reviewed-by: Dean Rasheed <email@example.com>
Continue reading Waiting for PostgreSQL 16 – Non-decimal integer literals