From 8d2e9a9dbd56aabb9273fbc30ca6c03d6f24b996 Mon Sep 17 00:00:00 2001 From: Peter Eisentraut Date: Mon, 17 Dec 2012 22:45:20 -0500 Subject: [PATCH] doc: Put PL/pgSQL RAISE USING keywords into a list Karl O. Pinc --- doc/src/sgml/plpgsql.sgml | 52 ++++++++++++++++++++++++++++----------- 1 file changed, 38 insertions(+), 14 deletions(-) diff --git a/doc/src/sgml/plpgsql.sgml b/doc/src/sgml/plpgsql.sgml index b33c41e02a..95cf4b6b46 100644 --- a/doc/src/sgml/plpgsql.sgml +++ b/doc/src/sgml/plpgsql.sgml @@ -3288,20 +3288,44 @@ RAISE NOTICE 'Calling cs_create_job(%)', v_job_id; You can attach additional information to the error report by writing USING followed by option = expression items. The allowed - option keywords are - MESSAGE, DETAIL, HINT, and - ERRCODE, while each expression can be any string-valued - expression. - MESSAGE sets the error message text (this option can't - be used in the form of RAISE that includes a format - string before USING). - DETAIL supplies an error detail message, while - HINT supplies a hint message. - ERRCODE specifies the error code (SQLSTATE) to report, - either by condition name as shown in , - or directly as a five-character SQLSTATE code. + class="parameter">expression items. Each + expression can be any + string-valued expression. The allowed option key words are: + + + + MESSAGE + + Sets the error message text. This option can't be used in the + form of RAISE that includes a format string + before USING. + + + + + DETAIL + + Supplies an error detail message. + + + + + HINT + + Supplies a hint message. + + + + + ERRCODE + + Specifies the error code (SQLSTATE) to report, either by condition + name, as shown in , or directly as a + five-character SQLSTATE code. + + + -- 2.40.0