Martijn van Oosterhout wrote:
-- Start of PGP signed section.
> On Wed, Aug 09, 2006 at 08:38:22AM +0100, Richard Huxton wrote:
> > There are three separate issues we seem to be talking about.
> >
> > 1. Namespaces - visibility or otherwise of objects
> > 2. Procedural state - something that looks like a shared variable
> > 3. Packaging - installation/dependency handling
> Well, it would be nice to have some clarification about the expected
> scope and lifetimes of these variables. If two different sessions
> change the values, what's supposed to happen?

Right, I am confused whether these are session or schema-local
variables.  What does Oracle support?  Looking at this:

it seems varaiable are per-session.

Oracle use packages dbms_pipe and dbms_alert for interprocess communication, not shared variables. For both packages exists emulation in orafunc on pgfoundry.


Chcete sdilet sve obrazky a hudbu s prateli?

---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
      choose an index scan if your joining column's datatypes do not

Reply via email to