PostgreSQL/Postgre SQL/RAISE DEBUG

Using the RAISE statement

   <source lang="sql">

postgres=# postgres=# postgres=# -- Using the RAISE statement postgres=# postgres=# CREATE FUNCTION raise_test () RETURNS integer AS " postgres"# DECLARE postgres"# -- Declare an integer variable for testing. postgres"# an_integer INTEGER = 1; postgres"# BEGIN postgres"# -- Raise a debug level message. postgres"# RAISE DEBUG ""The raise_test() function began.""; postgres"# an_integer = an_integer + 1; postgres"# postgres"# -- Raise a notice stating that the an_integer variable was changed, postgres"# -- then raise another notice stating its new value. postgres"# RAISE NOTICE ""Variable an_integer was changed.""; postgres"# RAISE NOTICE ""Variable an_integer"s value is now %."",an_integer; ERROR: syntax error at or near "s" at character 501 LINE 13: RAISE NOTICE ""Variable an_integer"s value is now %."",a...

                                               ^

postgres=# postgres=# -- Raise an exception. postgres=# RAISE EXCEPTION ""Variable % changed. Transaction aborted."",an_integer; ERROR: syntax error at or near "RAISE" at character 1 LINE 1: RAISE EXCEPTION ""Variable % changed. Transaction aborted."...

       ^

postgres=# postgres=# RETURN 1; ERROR: syntax error at or near "RETURN" at character 1 LINE 1: RETURN 1;

       ^

postgres=# END; WARNING: there is no transaction in progress COMMIT postgres=# postgres=# postgres=# SELECT raise_test(); NOTICE: Variable an_integer was changed. NOTICE: Variable an_integer value is now 2. ERROR: Variable 2 changed. Aborting transaction. postgres=#

      </source>