From: | elein <elein(at)sbcglobal(dot)net> |
---|---|
To: | "John Lim" <heyjohnlim(at)yahoo(dot)com>, pgsql-general(at)postgresql(dot)org |
Cc: | elein(at)varlena(dot)com |
Subject: | Re: pl/pgsql and global variables |
Date: | 2003-04-09 23:45:19 |
Message-ID: | 200304092349.h39Nn8Vm261302@pimout2-ext.prodigy.net |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Use plpython. There you will have session duration
variables available. If you need multi-connection
"global" variables, put them in a table (duh :-)
elein(at)varlena(dot)com
On Wednesday 09 April 2003 04:24, John Lim wrote:
> Hello,
>
> We are trying to select which procedural language to use with postgresql.
> We are familiar with oracle and PL/SQL and were pleased with the close
> match with PL/pgSQL.
>
> However we need access to global variables in PL/pgSQL. I cannot find any
> mention of this in the docs. A search on google was not helpful as it just
> pointed back at the docs. Is this feature available, or do we have to use
> some of the other available languages such as PL/TCL or PL/Python?
>
> Also any advice on the stability of any of the PL/languages would be
> appreciated.
>
> Thanks again for reading and answering this.
>
> John Lim
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 3: if posting/reading through Usenet, please send an appropriate
> subscribe-nomail command to majordomo(at)postgresql(dot)org so that your
> message can get through to the mailing list cleanly
--
----------------------------------------------------------------------------------------
elein(at)varlena(dot)com Database Consulting www.varlena.com
In memoriam Dr. Anita Borg http://www.iwt.org/home.html
From | Date | Subject | |
---|---|---|---|
Next Message | Martijn van Oosterhout | 2003-04-10 00:38:50 | Re: Key features for data warehousing |
Previous Message | Bruno Wolff III | 2003-04-09 22:41:03 | Re: csv files |