On 12/02/2010 12:27 PM, ma...@manfbraun.de wrote:
Hello !
a)
The idea with to test a RAISE statement with an prefix, could
be good. But I am just that new, I could not make it working.
I have not understand, where I can issue direct sql statements
and it looks like, the RAISE is not possible with plSql:
mbtest=# RAISE NOTICE 'mynotice: %', 'hello';
ERROR: syntax error at or near "RAISE"
LINE 1: RAISE NOTICE 'mynotice: %', 'hello';
It is available in plpgsql:
http://www.postgresql.org/docs/9.0/interactive/plpgsql-errors-and-messages.html
If you are running 9.0+ you can use DO to run it at the psql prompt:
http://www.postgresql.org/docs/9.0/interactive/sql-do.html
--
Adrian Klaver
adrian.kla...@gmail.com
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
