Re: Global variables in plpgsql

From: Pavel Stehule <pavel(dot)stehule(at)gmail(dot)com>
To: Nick Raj <nickrajjain(at)gmail(dot)com>
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: Global variables in plpgsql
Date: 2011-04-11 19:34:55
Message-ID: BANLkTin7kk6iVgvmixno70sigoVB6vUZiw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Hello

2011/4/11 Nick Raj <nickrajjain(at)gmail(dot)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

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2011-04-11 19:44:12 fn_collation in FmgrInfo considered harmful
Previous Message Peter Eisentraut 2011-04-11 19:23:07 Re: how to keep/lock/ hide pg_hba.conf ?