Re: BUG #5968: DOCUMENTATION: SELECT synopsis omits RETURNING keyword

From: Gavin Flower <GavinFlower(at)archidevsys(dot)co(dot)nz>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: Gavin Flower <gavin(dot)flower(at)archidevsys(dot)co(dot)nz>, pgsql-bugs(at)postgresql(dot)org
Subject: Re: BUG #5968: DOCUMENTATION: SELECT synopsis omits RETURNING keyword
Date: 2011-04-08 09:22:09
Message-ID: 4D9ED3C1.6030103@archidevsys.co.nz
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

On 08/04/11 14:57, Tom Lane wrote:
> "Gavin Flower"<gavin(dot)flower(at)archidevsys(dot)co(dot)nz> writes:
>> I think the documentation of SELECT should include the keyword 'RETURNING'
>> in its synopsis.
> Huh? There's no SELECT RETURNING.
>
> regards, tom lane
The 'WITH' clause is described in the synopsis for 'SELECT' - and the
'WITH' clause uses the keyword 'RETURNING'.

and/with_query/ is:

/with_query_name/ [ (/column_name/ [, ...] ) ] AS (/select/ |/insert/ |/update/ |/delete/ )

So as the 'WITH' clause is defined in the synopsis, I would expect that
the synopsis for 'SELECT' should also mention the 'RETURNING' keyword -
but it does not.

There is an example in:

'7.8. WITH Queries (Common Table Expressions)'

WITH t AS (
UPDATE products SET price = price * 1.05
RETURNING *
)
SELECT * FROM t;

Regards,
Gavin

In response to

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Gavin Flower 2011-04-08 09:29:57 Re: BUG #5968: DOCUMENTATION: SELECT synopsis omits RETURNING keyword
Previous Message Brendan Jurd 2011-04-08 09:00:22 Re: Failed assert ((data - start) == data_size) in heaptuple.c