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 <nickrajjain@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

Hello

2011/4/11 Nick Raj <nickrajjain@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