Re: print command in sproc

From: Filip Rembiałkowski <plk(dot)zuber(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: print command in sproc
Date: 2007-10-30 12:02:25
Message-ID: 92869e660710300502t1fd5fd8ar6e718c41fa6c0cb@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

2007/10/30, Jorge Godoy <jgodoy(at)gmail(dot)com>:
> Em Tuesday 23 October 2007 07:17:53 Goboxe escreveu:
> > Hi,
> >
> > What is the equivalent MSSQL 'print' command in pg sproc?
>
> What does the MSSQL 'print' command "prints"?

It prints what you tell it to print :)

Goboxe: The key question is, what you need 'print' for?

For PL/PgSQL debugging, use RAISE NOTICE - or write your own logging functions

If you are using psql, and just want to emit some static text - use '\echo'

HTH.

--
Filip Rembiałkowski

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Pit M. 2007-10-30 12:12:41 Re: Problems with PostgreSQL DBI-Link / DBD-ODBC
Previous Message Richard Huxton 2007-10-30 11:05:09 Re: Fragments in tsearch2 headline