Thread: pgsql function for roman2decimal?
This really feels like something that should be part of a module and not the core code.
On Sat, Jun 27, 2020 at 5:02 PM Bruce Momjian <bruce@momjian.us> wrote:
On Sat, Jun 27, 2020 at 04:38:59PM -0400, F Bax wrote:
> I found simple code for PHP to convert roman numeral to decimal here:
>
> https://stackoverflow.com/questions/6265596/
> how-to-convert-a-roman-numeral-to-integer-in-php
>
> Can this be accomplished with a pgsql function?
Someone worked on this in 2017 but it was never added due to lack of
interest. I am sure it can be cleaned up and added to PG 14 if there is
demand:
https://www.postgresql.org/message-id/flat/CAGMVOduAJ9wKqJXBYnmFmEetKxapJxrG3afUwpbOZ6n_dWaUnA%40mail.gmail.com
--
Bruce Momjian <bruce@momjian.us> https://momjian.us
EnterpriseDB https://enterprisedb.com
The usefulness of a cup is in its emptiness, Bruce Lee
Erik Brandsberg
+1 (866) 433-2824 x 700
If the core code already does one direction (I didn't know this) then I would agree. It seems that both would make sense to be in a separate module, due to the rarity of use, possibly just as an "exotic function" module, which would have a lower barrier of entry to adding code to.
On Sat, Jun 27, 2020 at 5:24 PM Bruce Momjian <bruce@momjian.us> wrote:
On Sat, Jun 27, 2020 at 05:14:27PM -0400, Erik Brandsberg wrote:
> This really feels like something that should be part of a module and not the
> core code.
Well, we already do the numeric to Roman conversion, so doing the
reverse seems to make sense:
SELECT to_char(335, 'RN');
to_char
-----------------
CCCXXXV
--
Bruce Momjian <bruce@momjian.us> https://momjian.us
EnterpriseDB https://enterprisedb.com
The usefulness of a cup is in its emptiness, Bruce Lee
Erik Brandsberg
+1 (866) 433-2824 x 700