Re: echo/printf function in plpgsql - Mailing list pgsql-sql

From Andreas Joseph Krogh
Subject Re: echo/printf function in plpgsql
Date
Msg-id 200507200921.26644.andreak@officenet.no
Whole thread Raw
In response to Re: echo/printf function in plpgsql  (John DeSoi <desoi@pgedit.com>)
List pgsql-sql
On Wednesday 20 July 2005 01:39, John DeSoi wrote:
> On Jul 19, 2005, at 11:58 AM, Andreas Joseph Krogh wrote:
> > I see. Can I make the ouput somehow less verbose? It spits out a
> > lot of noise
> > for each "NOTICE":
>
> If you just want to output some information to the log, you can use
> something like this:
>
> raise log 't is %', t;
>
> If I recall correctly, the values to be inserted into the format
> string can only be variables, not expressions.

Thanks!

--
AJK


pgsql-sql by date:

Previous
From: John DeSoi
Date:
Subject: Re: echo/printf function in plpgsql
Next
From: Lindsay
Date:
Subject: ids from grouped rows