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 -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
