Re: echo/printf function in plpgsql

From: Andreas Joseph Krogh <andreak(at)officenet(dot)no>
To: pgsql-sql(at)postgresql(dot)org
Subject: Re: echo/printf function in plpgsql
Date: 2005-07-20 07:21:26
Message-ID: 200507200921.26644.andreak@officenet.no
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message Lindsay 2005-07-20 12:46:38 ids from grouped rows
Previous Message John DeSoi 2005-07-19 23:39:47 Re: echo/printf function in plpgsql