Re: pl/pgsql and global variables

"John Lim" <heyjohnlim(at)yahoo(dot)com> writes:
> However we need access to global variables in PL/pgSQL. I cannot find any
> mention of this in the docs.

That's because it's not there. However, if the feature exists in Oracle
then it would seem reasonable to add it to PL/pgSQL. Want to volunteer?

> Also any advice on the stability of any of the PL/languages would be
> appreciated.

plpgsql is by far the best-tested and most widely used, I believe.
If I had to choose a second-best, I'd probably bet on pltcl, which is
the oldest of the bunch and probably better-wrung-out than the others.

regards, tom lane