Re: INSERT ... RETURNING documentation - Mailing list pgsql-docs

From Tom Lane
Subject Re: INSERT ... RETURNING documentation
Date
Msg-id 1566148.1721943723@sss.pgh.pa.us
Whole thread Raw
In response to Re: INSERT ... RETURNING documentation  ("David G. Johnston" <david.g.johnston@gmail.com>)
List pgsql-docs
"David G. Johnston" <david.g.johnston@gmail.com> writes:
> On Thursday, July 25, 2024, PG Doc comments form <noreply@postgresql.org>
> wrote:
>> The grammar
>> [ RETURNING * | output_expression [ [ AS ] output_name ] [, ...] ]
>> seems wrong to me.

> Yes, the word returning makes it the returning clause.  This should be
> written:

> [ Returning { * | output_expression [ [ AS ] output_name ] } [, …] ]

Agreed.

> Related, select says:

> [ * | expression [ [ AS ] output_name ] [, …] ]

I imagine the RETURNING synopsis was copied from that one :-(
Yes, let's change that too.

            regards, tom lane



pgsql-docs by date:

Previous
From: "David G. Johnston"
Date:
Subject: Re: INSERT ... RETURNING documentation
Next
From: Bruce Momjian
Date:
Subject: pg_createsubscriber clarification