[HACKERS] Global variables in plpgsql
Hi, Can anyone know how to define global variable in plpgsql? Thanks Regards, Raj
Re: [HACKERS] Global variables in plpgsql
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
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