From: | Pavel Stehule <pavel(dot)stehule(at)gmail(dot)com> |
---|---|
To: | Tomáš Mudruňka <tomas(at)mudrunka(dot)cz> |
Cc: | Pgsql hackers <pgsql-hackers(at)postgresql(dot)org> |
Subject: | Re: [FeatureRequest] Base Convert Function |
Date: | 2010-12-21 20:32:28 |
Message-ID: | AANLkTi=qp2ZtwgMRDBfaPC8P5nzodk-8qYkNwm7PG=kb@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
Hello
Dne 21. prosince 2010 21:11 Tomáš Mudruňka <tomas(at)mudrunka(dot)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 <fgp(at)phlo(dot)org> wrote:
>> On Dec21, 2010, at 12:48 , Robert Haas wrote:
>>> 2010/12/21 Tomáš Mudruňka <tomas(at)mudrunka(dot)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: harvie(at)jabbim(dot)cz, ICQ: 283782978
>
> --
> Sent via pgsql-hackers mailing list (pgsql-hackers(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-hackers
>
From | Date | Subject | |
---|---|---|---|
Next Message | Peter Eisentraut | 2010-12-21 21:14:31 | Re: wCTE behaviour |
Previous Message | Andres Freund | 2010-12-21 20:28:15 | Re: The cost of visibillity testing? (gin-search) |