Horton

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

Tom Lane <tgl@sss.pgh.pa.us>

View on postgr.es
Commit: 172e6b3adb2e2749883ad0746172e4cf97139961
Author: Tom Lane <tgl@sss.pgh.pa.us>
Date: 2025-01-22T20:18:50Z
Releases: 18.0 
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: https://postgr.es/m/CAMWA6ybh4M1VQqpmnu2tfSwO+3gAPeA8YKnMHVADeB=XDEvT_A@mail.gmail.com

Files

PathChange+/−
doc/src/sgml/func.sgml modified +15 −2
src/backend/utils/adt/formatting.c modified +224 −51
src/test/regress/expected/numeric.out modified +78 −0
src/test/regress/sql/numeric.sql modified +33 −0

Documentation touched

Discussion