Hello, Pavel. You wrote:
PS> Hello PS> Dne 21. prosince 2010 21:11 Tomáš Mudruňka <to...@mudrunka.cz> napsal(a): >> >> 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 :-) >> PS> * It isn't a typical and often request, PS> * There are not hard breaks for custom implementation, PS> * You can use plperu or plpython based solutions, PS> * It's not part of ANSI SQL But MySQL has such function. What's wrong with us? ;) PS> Regards PS> Pavel Stehule >> 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 >> -- With best wishes, Pavel mailto:pa...@gf.microolap.com -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers