Re: Packages in oracle Style

From: <coutinho(at)mondriantecnologia(dot)com>
To: Pavel Stehule <pavel(dot)stehule(at)gmail(dot)com>
Cc: Zdenek Kotala <Zdenek(dot)Kotala(at)sun(dot)com>, pgsql-hackers(at)postgresql(dot)org
Subject: Re: Packages in oracle Style
Date: 2008-05-31 13:20:54
Message-ID: 02389fff58bdfb93f27630ae8e0a8ee0@localhost
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers


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

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
>>

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Kevin Walker 2008-05-31 13:54:54 Re: proposal: Preference SQL
Previous Message Jan Urbański 2008-05-31 11:33:54 Re: proposal: Preference SQL