Re: printing variable values in pl/pgsql functions

you can use
RAISE NOTICE 'i want to print % and %', var1,var2;

then run your function and click the MESSAGE tab at the bottom of your query
analyzer screen and you'll see sometime like

NOTICE: i want to print <value of var 1> and <value of var2

you can use any number of RAISE NOTICE statements as you want and they will
be printed in order under messages.

I hope this helps
~Jas

On 5/8/07, Harpreet Dhaliwal <harpreet(dot)dhaliwal01(at)gmail(dot)com> wrote:
>
>
>
> Hi,
>
> I have a pl/pgsql in which i have to print various variable values during
> the execution of the function to see
> what values are getting populated inside those variables with due course
> of time.
>
> PRINT <variable name>
> doesn't work.
>
> Can anyone tell me how to print these values??
>
>
> Thanks,
> ~Harpreet
>