] printing variable values in pl/pgsql functions
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
doesn't work.
Can a
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 and wrote:
Hi,
I have a pl/pgsql in which i have to print various variable value
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
doesn't work.
Can anyone tell me how to print these values??
Thanks,
~Harpreet
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
doesn't work.
Can anyone tell me how to print these values??
Thanks,
~Harpreet