Re: Add small detail to RAISE statement descripton

From: jian he <jian(dot)universality(at)gmail(dot)com>
To: Igor Gnatyuk <ig953or(at)gmail(dot)com>
Cc: pgsql-docs(at)lists(dot)postgresql(dot)org
Subject: Re: Add small detail to RAISE statement descripton
Date: 2024-05-15 09:18:23
Message-ID: CACJufxEcbGJb5f7NGQ+9WXaK2ihBZbfQBUnwR56r-V3SdxkKJg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-docs

On Tue, May 14, 2024 at 11:09 PM Igor Gnatyuk <ig953or(at)gmail(dot)com> wrote:
>
> Hi,
>
> There is a slight syntax inaccuracy in the description of the RAISE
> statement - assignments of parameter values in USING.
> (Chapter 43. PL/pgSQL — SQL Procedural Language / 43.9 Errors and
> Messages / 43.9.1 Reporting Errors and Messages):
>
> "...You can attach additional information to the error report by
> writing USING followed by option = expression items..."
> It should, apparently, be like this: "...option { = | := } expression..."
>
> The patch corrects this little omission. Attached: fix_doc_raise.patch
>
> Regards, Igor Gnatyuk

while at it,
I found out there is no brief explanation of:
<replaceable class="parameter">condition_name</replaceable>
and
<replaceable class="parameter">sqlstate</replaceable>
should we add it?

one more minor thing.

You can attach additional information to the error report by writing
<literal>USING</literal> followed by <replaceable
class="parameter">option</replaceable> { = | := } <replaceable
class="parameter">expression</replaceable> items. Each

we are not in <synopsis>, maybe

You can attach additional information to the error report by writing
<literal>USING</literal> followed by <replaceable
class="parameter">option</replaceable> = <replaceable
class="parameter">expression</replaceable> or
<replaceable class="parameter">option</replaceable> :=
<replaceable class="parameter">expression</replaceable>
items

will make it more clear.

In response to

Responses

Browse pgsql-docs by date

  From Date Subject
Next Message Igor Gnatyuk 2024-05-17 08:39:35 Re: Add small detail to RAISE statement descripton
Previous Message Robert Haas 2024-05-14 20:07:09 Re: Add minimal C example and SQL registration example for custom table access methods.