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 f...@phlo.org wrote:
On Dec21, 2010, at 12:48 , Robert Haas wrote:
2010/12/21 Tomáš Mudruňka to...@mudrunka.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: har...@jabbim.cz, ICQ: 283782978
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers