Search Postgresql Archives

Re: RAISE function misuse ?

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



Michael Fuhr wrote:
On Mon, Apr 03, 2006 at 05:44:18PM +0200, Patrick Refondini wrote:

idns_target=# select test();
INFO:  hello !
CONTEXT:  SQL statement "SELECT  hello()"
PL/pgSQL function "test" line 2 at perform


[...]


1. Is there anything wrong using RAISE this way.


Not in the sense of the code doing something it shouldn't.
Is there a better way to output text from within a function ?


2. Is there a way to get rid of the output:
CONTEXT:  SQL statement "SELECT  hello()"
PL/pgSQL function "test" line 2 at perform


test=> \set VERBOSITY terse
Great ! Exactely what I was looking for.

Thanks,

Patrick

test=> select test();
INFO:  hello !
test ------ (1 row)




[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux