Re: BUG #5968: DOCUMENTATION: SELECT synopsis omits RETURNING keyword - Mailing list pgsql-bugs

From Tom Lane
Subject Re: BUG #5968: DOCUMENTATION: SELECT synopsis omits RETURNING keyword
Date
Msg-id 11485.1302273769@sss.pgh.pa.us
Whole thread Raw
In response to Re: BUG #5968: DOCUMENTATION: SELECT synopsis omits RETURNING keyword  (Gavin Flower <GavinFlower@archidevsys.co.nz>)
Responses Re: BUG #5968: DOCUMENTATION: SELECT synopsis omits RETURNING keyword
List pgsql-bugs
Gavin Flower <GavinFlower@archidevsys.co.nz> writes:
> I found were RETURNING is defined, so I was confused...
> ...
> However, may be it would still be good to mention it on the SELECT page?

It is mentioned --- the subsection on the WITH clause points out that
you typically want to use RETURNING on an INSERT/UPDATE/DELETE in WITH.

I thought about providing an example, but couldn't come up with one that
was both simple and compelling.  There's no strong reason to do WITH
(something RETURNING) SELECT ... --- you might as well just do the work
in a straight "something RETURNING" statement.  To do something that
actually requires the more complex syntax, you'd need to join the
RETURNING result to another table or another RETURNING result.
Creating an easily understandable example that involves that is beyond
my powers at this time of the morning.

            regards, tom lane

pgsql-bugs by date:

Previous
From: Alvaro Herrera
Date:
Subject: Re: Failed assert ((data - start) == data_size) in heaptuple.c
Next
From: Alvaro Herrera
Date:
Subject: Re: BUG #5956: quiero crear una base de datos -E LATIN1 en la version 8.4