Hello 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 :-) >
* It isn't a typical and often request, * There are not hard breaks for custom implementation, * You can use plperu or plpython based solutions, * It's not part of ANSI SQL Regards 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 > -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
