Re: [HACKERS] [FeatureRequest] Base Convert Function

2010-12-21 Thread Robert Haas
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

Re: [HACKERS] [FeatureRequest] Base Convert Function

2010-12-21 Thread Pavel Stehule
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

Re: [HACKERS] [FeatureRequest] Base Convert Function

2010-12-21 Thread Florian Pflug
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

Re: [HACKERS] [FeatureRequest] Base Convert Function

2010-12-21 Thread Tomáš Mudruňka
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

Re: [HACKERS] [FeatureRequest] Base Convert Function

2010-12-21 Thread Pavel Stehule
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

Re: [HACKERS] [FeatureRequest] Base Convert Function

2010-12-21 Thread Pavel Golub
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

Re: [HACKERS] [FeatureRequest] Base Convert Function

2010-12-21 Thread Kenneth Marshall
On Tue, Dec 21, 2010 at 11:28:17PM +0200, Pavel Golub wrote: 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

Re: [HACKERS] [FeatureRequest] Base Convert Function

2010-12-21 Thread Andrew Dunstan
On 12/21/2010 04:28 PM, Pavel Golub wrote: 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? ;) Our

Re: [HACKERS] [FeatureRequest] Base Convert Function

2010-12-21 Thread Pavel Golub
Hello. Guys, guys! It was only a joke! :) Please accept my appologies. Anyway I find such function usefull even though I still hadn't situation when it might be needed. You wrote: AD On 12/21/2010 04:28 PM, Pavel Golub wrote: PS * It isn't a typical and often request, PS * There are not

Re: [HACKERS] [FeatureRequest] Base Convert Function

2010-12-21 Thread Robert Haas
On Tue, Dec 21, 2010 at 4:57 PM, Pavel Golub pa...@microolap.com wrote: Anyway I find such function usefull even though I still hadn't situation when it might be needed. Yeah, I agree. I'm not sure we should add it to core, but it's certainly just as useful as many things we have in contrib.

[HACKERS] [FeatureRequest] Base Convert Function

2010-12-20 Thread Tomáš Mudruňka
Hi! 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)...