| From: | Pavel Stehule <stehule(at)kix(dot)fsv(dot)cvut(dot)cz> |
|---|---|
| To: | Amin Schoeib <aschoeib(at)4tek(dot)de> |
| Cc: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: Output from PLPGSQL |
| Date: | 2003-09-03 11:52:24 |
| Message-ID: | Pine.LNX.4.44.0309031348410.22021-100000@kix.fsv.cvut.cz |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
hello
use raise notice ''some message'';
http://www.postgresql.org/docs/7.3/interactive/plpgsql-errors-and-messages.html
try to read documentation for plpgsq (very usefull)
http://www.postgresql.org/docs/7.3/interactive/plpgsql.html
and chapter for converison from Oracle
http://www.postgresql.org/docs/7.3/interactive/plpgsql-porting.html
bye
Pavel
On Wed, 3 Sep 2003, 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
>
> Thanxx
>
> Schoeib
>
> 4Tek Gesellschaft für angewandte Informationstechnologien mbH
> Schoeib Amin
> Tel. +49 (0) 69 697688-132
> Fax. +49 (0) 69 697688-111
> http://www.4tek.de
>
>
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Bruno BAGUETTE | 2003-09-03 12:30:22 | What is the good equivalent for ENUM ? |
| Previous Message | Larry Rosenman | 2003-09-03 11:47:51 | Re: Output from PLPGSQL |