Re: logging messages from inside pgPLSQL routine? - Mailing list pgsql-sql

On Thu, Aug 21, 2003 at 05:21:47PM -0700, Drew Wilson wrote:
> I'mm trying to debug something inside my PLSQL routine. How do I print 
> out error messages from inside my function?

RAISE NOTICE ''Foobar is %'', foobar;

Where "foobar" is a variable. The documentation mentions this in several
places and examples.

-Roberto

-- 
+----|        Roberto Mello   -    http://www.brasileiro.net/  |------+
+       Computer Science Graduate Student, Utah State University      +
+       USU Free Software & GNU/Linux Club - http://fslc.usu.edu/     +
Compiling...Linking...Dialing Copyright Lawyer...