Re: Oracle Style packages on postgres

Thomas Hallgren <thhal@mailblocks.com>

From: Thomas Hallgren <thhal@mailblocks.com>
To: Satoshi Nagayasu <nagayasus@nttdata.co.jp>
Cc: "rmm@sqlisor.com" <rmm@sqlisor.com>, pgsql-hackers@postgresql.org
Date: 2005-05-09T05:36:21Z
Lists: pgsql-hackers
Satoshi Nagayasu wrote:

>>    An oracle package is created when first referenced. Its initialization
>>    code is run once (ie costly queries to populate session wide package
>>    params) and the package dies at the end of the session
>>    An analogy with OOP is that it's like having a single class instance
>>    available for the duration of a session.
>>
PL/Java has an object called "Session" that does exactly this. It is not
available from other languages at present. Are Packages supposed to be
cross-language?

Regards,
Thomas Hallgren