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-----