Thread: Global variables in plpgsql
Hi,<br />Can anyone know how to define global variable in plpgsql? <br />Thanks<br /><br />Regards,<br /><font color="#888888">Raj</font><br/>
On Mon, Apr 11, 2011 at 7:33 AM, Nick Raj <[email protected]> wrote: > Can anyone know how to define global variable in plpgsql? I expect you should consult the manual page on the command CREATE TABLE. That's what would be the nearest SQL equivalent to a "global variable." http://www.postgresql.org/docs/9.0/static/sql-createtable.html -- http://linuxfinances.info/info/postgresql.html
Hello 2011/4/11 Nick Raj <[email protected]>: > Hi, > Can anyone know how to define global variable in plpgsql? > Thanks > > Regards, > Raj > plpgsql doesn't support global or session variables. There are a few techniques - you can emulate it http://www.postgresql.org/docs/8.3/static/plperl-global.html Regards Pavel Stehule