On Tue, Feb 17, 2015 at 1:08 PM, John McKown [via PostgreSQL] < ml-node+s1045698n5838306...@n5.nabble.com> wrote:
> I haven't seen any one else reply. I don't know if you've gotten a > solution. But the following seemed to work for me: > > mine apparently got bounced... > WITH serie AS ( > select s, s*10 as computing > from generate_series(1,10) as s > ) > INSERT INTO test_insert_returning (some_value) > SELECT computing > FROM serie > RETURNING gid, some_value; > or, "RETURNING some_value / 10" > From my reading on the RETURNING phrase, you can only return values from > the table into which you are doing the INSERT. Not any other table or view > which might be referenced. > > This is correct; and I am curious on the use case that requires otherwise. David J. -- View this message in context: http://postgresql.nabble.com/Missing-table-from-in-INSERT-RETURNING-tp5838274p5838309.html Sent from the PostgreSQL - general mailing list archive at Nabble.com.
