Re: echo/printf function in plpgsql

From: John DeSoi <desoi(at)pgedit(dot)com>
To: Andreas Joseph Krogh <andreak(at)officenet(dot)no>
Cc: pgsql-sql(at)postgresql(dot)org
Subject: Re: echo/printf function in plpgsql
Date: 2005-07-19 23:39:47
Message-ID: DCD52400-C591-4F84-9176-C12EF554DAF2@pgedit.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql


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.

John DeSoi, Ph.D.
http://pgedit.com/
Power Tools for PostgreSQL

In response to

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Andreas Joseph Krogh 2005-07-20 07:21:26 Re: echo/printf function in plpgsql
Previous Message Chris Travers 2005-07-19 22:54:04 Re: difference between all RDBMSs