projects / users / rhaas / postgres.git / commit
? search:
summary | shortlog | log | commit | commitdiff | tree
(parent: ccadf73) | patch
Add to_bin() and to_oct().
authorNathan Bossart <nathan@postgresql.org>
Wed, 23 Aug 2023 14:49:03 +0000 (07:49 -0700)
committerNathan Bossart <nathan@postgresql.org>
Wed, 23 Aug 2023 14:49:03 +0000 (07:49 -0700)
commit260a1f18dae8729f99cefe4e1f759193fd6bedd0
tree63fa3c210deaf8877d786c03351eadc88d73a734tree
parentccadf73163ca88bdaa74b8223d4dde05d17f550bcommit | diff
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
Discussion: https://postgr.es/m/Y6IyTQQ/TsD5wnsH%40vm3.eradman.com
doc/src/sgml/func.sgml diff | blob | blame | history
src/backend/utils/adt/varlena.c diff | blob | blame | history
src/include/catalog/pg_proc.dat diff | blob | blame | history
src/test/regress/expected/strings.out diff | blob | blame | history
src/test/regress/sql/strings.sql diff | blob | blame | history
Robert Haas's development tree.