Re: [HACKERS] Packages in oracle Style

2008-06-01 Thread Pavel Stehule
2008/6/1 Harald Armin Massa <[EMAIL PROTECTED]>: > Joe and all, > >> The below listed tarball is out of date at this point, but I have updated >> code laying around if someone really wanted it: >> http://www.joeconway.com/sessfunc.tar.gz >> I've used variations of this over the years on several pr

Re: [HACKERS] Packages in oracle Style

2008-06-01 Thread Harald Armin Massa
Joe and all, > The below listed tarball is out of date at this point, but I have updated > code laying around if someone really wanted it: > http://www.joeconway.com/sessfunc.tar.gz > I've used variations of this over the years on several projects. is someone able and willing to provide this tar

Re: [HACKERS] Packages in oracle Style

2008-05-31 Thread Pavel Stehule
Hello 2008/5/31 <[EMAIL PROTECTED]>: > > 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','[EMAIL PROTECTED]'); > > select get_session('USE

Re: [HACKERS] Packages in oracle Style

2008-05-31 Thread Joe Conway
[EMAIL PROTECTED] wrote: I have implemented a solution for global variables implemented in plpython and I need implement this in c :) The below listed tarball is out of date at this point, but I have updated code laying around if someone really wanted it: http://www.joeconway.com/sessfunc.

Re: [HACKERS] Packages in oracle Style

2008-05-31 Thread coutinho
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','[EMAIL PROTECTED]'); select get_session('USER'); > coutinho select get_session('EMAIL'); > [EMAIL

Re: [HACKERS] Packages in oracle Style

2008-05-28 Thread Pavel Stehule
2008/5/27 Zdenek Kotala <[EMAIL PROTECTED]>: > 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

[HACKERS] Packages in oracle Style

2008-05-25 Thread Coutinho
I want to start working to implement packages in PostgreSQL and would like to learn how to change the tables of the catalogue. I want to useit pg_namespace table to create a "sub-schema" that will be used to group the functions like in Oracle -- Nabucodonosor Coutinho -- Sent via pgsql-hackers