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 <[EMAIL PROTECTED]> 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
