Re: Output from PLPGSQL

On Wednesday 03 September 2003 12:19, Amin Schoeib wrote:
> Hi,
> How can I make textoutput (for example for tracing the code) in PLPGSQL.
> In Oracle you can do that using dbms.output.put_line

RAISE NOTICE ''My counter is % with total %'',i,run_tot;

Double-quoted string as usual in plpgsql - won't handle expressions for the
string part.

--
  Richard Huxton
  Archonet Ltd