Re: [HACKERS] Global variables in plpgsql

2011-04-11 Thread Pavel Stehule
Hello 2011/4/11 Nick Raj : > 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

Re: [HACKERS] Global variables in plpgsql

2011-04-11 Thread Christopher Browne
On Mon, Apr 11, 2011 at 7:33 AM, Nick Raj 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

[HACKERS] Global variables in plpgsql

2011-04-11 Thread Nick Raj
Hi, Can anyone know how to define global variable in plpgsql? Thanks Regards, Raj