Re: convert very large unsigned numbers to base62? - Mailing list pgsql-general

From Stuart Cooper
Subject Re: convert very large unsigned numbers to base62?
Date
Msg-id 7fc8628a0805141752q3e17d6d1md2425405591d86da@mail.gmail.com
Whole thread Raw
In response to convert very large unsigned numbers to base62?  ("D. Dante Lorenso" <dante@lorenso.com>)
Responses Re: convert very large unsigned numbers to base62?  ("D. Dante Lorenso" <dante@lorenso.com>)
List pgsql-general
> 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.

pgsql-general by date:

Previous
From: "Dann Corbit"
Date:
Subject: Re: bug on ALTER TABLE
Next
From: Gregory Stark
Date:
Subject: Re: psql \pset pager