print command in sproc

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"?

--
Jorge Godoy <jgodoy@gmail.com>

2007/10/30, Jorge Godoy <jgodoy@gmail.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