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
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
Hi,
Can anyone know how to define global variable in plpgsql?
Thanks
Regards,
Raj