Undocumented := alternative in using option of raise statement
The following documentation comment has been logged on the website:
Page: https://www.postgresql.org/docs/16/plpgsql-errors-and-messages.html
Description:
The using option is documented as follows for all variants of the raise
statement:
USING option = expression [, ... ]
However, since "do $$ begin raise notice using message := 'foo'; end $$;"
works and the alternative to "=" is documented in
https://www.postgresql.org/docs/current/plpgsql-statements.html#PLPGSQL-STATEMENTS-ASSIGNMENT
I suggest to change the grammar to
USING option { := | = } expression [, ... ]
for the raise statement.
On Mon, Jul 22, 2024 at 8:38 PM PG Doc comments form
<noreply@postgresql.org> wrote:
The following documentation comment has been logged on the website:
Page: https://www.postgresql.org/docs/16/plpgsql-errors-and-messages.html
Description:The using option is documented as follows for all variants of the raise
statement:USING option = expression [, ... ]
However, since "do $$ begin raise notice using message := 'foo'; end $$;"
works and the alternative to "=" is documented in
https://www.postgresql.org/docs/current/plpgsql-statements.html#PLPGSQL-STATEMENTS-ASSIGNMENT
I suggest to change the grammar toUSING option { := | = } expression [, ... ]
for the raise statement.
I think this has been committed.
https://git.postgresql.org/cgit/postgresql.git/commit/?id=56c6be57af6bd1c7eb7dff50e5f169ced4ed3045
you can check latest doc at:
https://www.postgresql.org/docs/devel/plpgsql-errors-and-messages.html
On 22 Jul 2024, at 15:18, jian he <jian.universality@gmail.com> wrote:
On Mon, Jul 22, 2024 at 8:38 PM PG Doc comments form
<noreply@postgresql.org> wrote:The following documentation comment has been logged on the website:
Page: https://www.postgresql.org/docs/16/plpgsql-errors-and-messages.html
Description:The using option is documented as follows for all variants of the raise
statement:USING option = expression [, ... ]
However, since "do $$ begin raise notice using message := 'foo'; end $$;"
works and the alternative to "=" is documented in
https://www.postgresql.org/docs/current/plpgsql-statements.html#PLPGSQL-STATEMENTS-ASSIGNMENT
I suggest to change the grammar toUSING option { := | = } expression [, ... ]
for the raise statement.
I think this has been committed.
https://git.postgresql.org/cgit/postgresql.git/commit/?id=56c6be57af6bd1c7eb7dff50e5f169ced4ed3045you can check latest doc at:
https://www.postgresql.org/docs/devel/plpgsql-errors-and-messages.html
Thanks Jan for letting me know. Looks good.
Next time I'll check the devel version of the docs before submitting a correction.