Re: Packages in oracle Style

["Pavel Stehule" <pavel(dot)stehule(at)gmail(dot)com>]

Hello

2008/5/31  <coutinho(at)mondriantecnologia(dot)com>:
>
> I have implemented a solution for global variables implemented in plpython and I need implement this in c :)
>
> My implementation:
>
> select set_session('USER','coutinho');
> select set_session('EMAIL','coutinho(at)mondriantecnologia(dot)com');
>
> select get_session('USER');
>> coutinho
>
> select get_session('EMAIL');
>> coutinho(at)mondriantecnologia(dot)com
>
>

this is too simple :( data are stored in text format, not in native Datum format

Regards
Pavel Stehule

> On Wed, 28 May 2008 22:13:31 +0200, "Pavel Stehule" <pavel(dot)stehule(at)gmail(dot)com> wrote:
>> 2008/5/27 Zdenek Kotala <Zdenek(dot)Kotala(at)sun(dot)com>:
>>> Coutinho napsal(a):
>>>>
>>>> this is listed on TODO:
>>>> http://www.postgresql.org/docs/faqs.TODO.html
>>>>
>>>> Add features of Oracle-style packages (Pavel)
>>>>
>>
>> My last idea was only global variables for plpgsql. It needs hack of
>> plpgsql :(. But it's can be simple work.
>>
>> Pavel
>>
>>>
>>> I see. Sorry I overlooked it. I think Pavel Stehule will help you. He
>> has
>>> idea how to do it.
>>>
>>>                Zdenek
>>>
>>> --
>>> 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
>>>
>
>