pgsql: Support RN (roman-numeral format) in to_number().

Started by Tom Laneover 1 year ago1 messagescomitters
Jump to latest
#1Tom Lane
tgl@sss.pgh.pa.us

Support RN (roman-numeral format) in to_number().

We've long had roman-numeral output support in to_char(),
but lacked the reverse conversion. Here it is.

Author: Hunaid Sohail <hunaidpgml@gmail.com>
Reviewed-by: Maciek Sakrejda <m.sakrejda@gmail.com>
Reviewed-by: Tom Lane <tgl@sss.pgh.pa.us>
Reviewed-by: Tomas Vondra <tomas@vondra.me>
Discussion: /messages/by-id/CAMWA6ybh4M1VQqpmnu2tfSwO+3gAPeA8YKnMHVADeB=XDEvT_A@mail.gmail.com

Branch
------
master

Details
-------
https://git.postgresql.org/pg/commitdiff/172e6b3adb2e2749883ad0746172e4cf97139961

Modified Files
--------------
doc/src/sgml/func.sgml | 17 ++-
src/backend/utils/adt/formatting.c | 275 +++++++++++++++++++++++++++-------
src/test/regress/expected/numeric.out | 78 ++++++++++
src/test/regress/sql/numeric.sql | 33 ++++
4 files changed, 350 insertions(+), 53 deletions(-)