Skip site navigation (1) Skip section navigation (2)

Re: Packages in oracle Style

From: "Pavel Stehule" <pavel(dot)stehule(at)gmail(dot)com>
To: coutinho(at)mondriantecnologia(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 17:37:46
Message-ID: 162867790805311037h718d5dbdtb5f16912abea646f@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-hackers
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
>>>
>
>

In response to

pgsql-hackers by date

Next:From: Zdenek KotalaDate: 2008-05-31 17:49:09
Subject: Re: Proposal - Collation at database level
Previous:From: Tom LaneDate: 2008-05-31 16:23:35
Subject: Re: Overhauling GUCS

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group