Thread: roman numerals

I see there's a way to convert to a roman numeral using
to_char(10,'RN') will give you 'X'.
How can i go the other way?  i was looking through the docs, but i
couldn't find the right arguments to give to to_number('X',???) to get
10.

regards,

--brian

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1


> I see there's a way to convert to a roman numeral using
> to_char(10,'RN') will give you 'X'.
> How can i go the other way?

You cannot, but it is on a "TODO" list within the source code.

Until then, you may want to take a look at the perl module Math::Roman

http://theoryx5.uwinnipeg.ca/mod_perl/cpan-search?distinfo=3092

- --
Greg Sabino Mullane greg@turnstep.com
PGP Key: 0x14964AC8 200305051023

-----BEGIN PGP SIGNATURE-----
Comment: http://www.turnstep.com/pgp.html

iD8DBQE+tnWqvJuQZxSWSsgRAiHdAJ48nW/m7msqqQUOlEaKieNQ8bmdmQCgr+Lx
mjA/yTu9JBtHuuyf8MrMnec=
=6c9j
-----END PGP SIGNATURE-----