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.
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