Re: [FeatureRequest] Base Convert Function

Thx for you answers :-)
Well... i know that i can write my own plugin and i am familiar with C so
this is not the problem, but i think that such feature should be
implemented directly in PgSQL because there are already functions for
converting to/from base 16 so why don't make this more flexible and
generalize it to any other radix? It's quite simple to do and i don't see
any reason why 16 should be there and 8, 32 or 36 shouldn't :-)

peace

On Tue, 21 Dec 2010 15:04:03 +0100, Florian Pflug <fgp(at)phlo(dot)org> wrote:
> On Dec21, 2010, at 12:48 , Robert Haas wrote:
>> 2010/12/21 Tomáš Mudruňka <tomas(at)mudrunka(dot)cz>:
>>> Is there possibility of having internal base converting function in
>>> PgSQL?
>>> There are already functions for converting between decimal and
>>> hexadecimal
>>> notations i think pgsql can be able to convert between number with
>>> radixes
>>> from 1 to 36 (actually fast (de)encoding base36 is what i need)...
>>
>> It should be pretty easy to write such a function in C, perhaps using
>> strtol() or strtoul().
>
> If you're not comfortable doing this in C, you might also want to
consider
> one of procedural languages pl/pgsql, pl/perl, pl/python. pl/pgsql is
> probably
> only viable if you just need this for ints and bigints, unless you don't
> care about performance.
>
> best regards,
> Florian Pflug

--
S pozdravem
Best regards
Tomáš Mudruňka - Spoje.net / Arachne Labs

XMPP/Jabber: harvie(at)jabbim(dot)cz, ICQ: 283782978