Postgres Pro
Downloads
Home   >   mailing lists

Re: [despammed] PostgreSQL User-Defined Global Variables - Mailing list pgsql-novice

From Andreas Kretschmer
Subject Re: [despammed] PostgreSQL User-Defined Global Variables
Date
Msg-id 20050707050649.GA27586@webserv.wug-glas.de
Whole thread Raw
In response to PostgreSQL User-Defined Global Variables  ("Van Ingen, Lane" <lvaningen@ESNCC.com>)
List pgsql-novice
Tree view 
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    ===

pgsql-novice by date:

Previous
From: Michael Fuhr
Date:
Subject: Re: PostgreSQL User-Defined Global Variables
Next
From: "M. Edward (Ed) Borasky"
Date:
Subject: Installing 8.0.3 on Windows 2000 Server?