Thread: PostgreSQL User-Defined Global Variables
Is it possible, via standard PostgreSQL or an extension, to set up a user-defined global variable outside of a stored procedure,and be able to query against the value of that variable?
On Wed, Jul 06, 2005 at 03:16:56PM -0400, Van Ingen, Lane wrote: > > Is it possible, via standard PostgreSQL or an extension, to set > up a user-defined global variable outside of a stored procedure, > and be able to query against the value of that variable? Some people use temporary tables for storing such values. Another way would be to write set/get functions in a language that supports global storage (PL/Perl, PL/Tcl, PL/Python, etc.). See for example the set_var() and get_var() functions in the PL/Perl documentation: http://www.postgresql.org/docs/8.0/static/plperl-global.html -- Michael Fuhr http://www.fuhr.org/~mfuhr/
am 06.07.2005, um 15:16:56 -0400 mailte Van Ingen, Lane folgendes: > Is it possible, via standard PostgreSQL or an extension, to set up a > user-defined global variable outside of a stored procedure, and be > able to query against the value of that variable? You can use languages like plperl to store persistent data, a nice example is there: http://www.varlena.com/varlena/GeneralBits/ ( Show Previous Row Values in plperl) Regards, Andreas -- Andreas Kretschmer (Kontakt: siehe Header) Heynitz: 035242/47212, D1: 0160/7141639 GnuPG-ID 0x3FFF606C http://wwwkeys.de.pgp.net === Schollglas Unternehmensgruppe ===