Thread: 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 to > > USING 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 to >> >> USING 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 Thanks Jan for letting me know. Looks good. Next time I'll check the devel version of the docs before submitting a correction.