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