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
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 |