[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


Re: [HACKERS] Global variables in plpgsql

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

-- 
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers


Re: [HACKERS] Global variables in plpgsql

2011-04-11 Thread Pavel Stehule
Hello

2011/4/11 Nick Raj nickrajj...@gmail.com:
 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

-- 
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers