Dne 21. prosince 2010 12:48 Robert Haas <robertmh...@gmail.com> napsal(a): > 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(). Because PostgreSQL uses an extensible > architecture, you could load such a function into your copy of > PostgreSQL and use it in your environment even if it weren't part of > the core distribution. There are a number of existing "contrib" > modules that you can look at for examples of how to do this. > > Whether or not we'd accept a patch to add such a function to core or > contrib, I'm not sure. Nobody's written one yet...
Most used transformations are available from core now - just need a wrapper function. This functions isn't a clean, - should be based on int, long int or bytea? Pavel > > -- > Robert Haas > EnterpriseDB: http://www.enterprisedb.com > The Enterprise PostgreSQL Company > > -- > 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
