> I'd like to convert very large unsigned numbers (ala bigint) to a text > string using base62. I created this PL/PERL function to do the trick:
base 62 is cruel and unusual punishment. Introduce two more printing characters to your set a..z, A..Z, 0..9 such as "_" and "!" and do it in base 64 instead. There's probably plenty of standard tools and convertors to do things in base 64. Best regards, Stuart Cooper. -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
