Re: echo/printf function in plpgsql

On Tuesday 19 July 2005 17:18, Richard Huxton wrote:
> Andreas Joseph Krogh wrote:
> > Hi all!
> >
> > Is there a way of echo'ing a string(like "raise notice 'this is id%',
> > id") from plpgsql? I want to echo/print it to STDOUT 'cause the
> > notice-mechanism produces too much noise IMH.
>
> Your function is running in the backend. You don't have a STDOUT
> (although you might have redirected STDERR for logging).

I see. Can I make the ouput somehow less verbose? It spits out a lot of noise
for each "NOTICE":
====================
psql:ocs_process_projecct.sql:48: NOTICE: trying to insert parent_id: 87,
child_id: 91
CONTEXT: SQL statement "SELECT processSubProject( $1 , $2 , $3 )"
PL/pgSQL function "processsubproject" line 7 at perform
SQL statement "SELECT processSubProject( $1 , $2 , $3 )"
PL/pgSQL function "processsubproject" line 7 at perform
SQL statement "SELECT processSubProject( $1 , $2 , $3 )"
PL/pgSQL function "build_project_children" line 11 at perform
====================

--
AJk