Re: Output from PLPGSQL

From: Richard Huxton <dev(at)archonet(dot)com>
To: "Amin Schoeib" <aschoeib(at)4tek(dot)de>, <pgsql-general(at)postgresql(dot)org>
Subject: Re: Output from PLPGSQL
Date: 2003-09-03 19:03:24
Message-ID: 200309032003.24353.dev@archonet.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Peter Eisentraut 2003-09-03 19:25:59 Re: French translation
Previous Message Bruno BAGUETTE 2003-09-03 19:00:32 How many memory size takes numeric(3,0) ?