Re: [GENERAL] Combining INSERT with DELETE RETURNING

2017-03-24 Thread Thomas Kellerer
Alexander Farber schrieb am 24.03.2017 um 16:06: > the doc https://www.postgresql.org/docs/9.6/static/sql-delete.html states: > > "The syntax of the RETURNING list is identical to that of the output list of > SELECT." > > So I am trying to rewrite the INSERT .. ON CONFLICT DO NOTHING followed b

Re: [GENERAL] Combining INSERT with DELETE RETURNING

2017-03-24 Thread David G. Johnston
On Fri, Mar 24, 2017 at 8:06 AM, Alexander Farber < alexander.far...@gmail.com> wrote: > Good afternoon, > > the doc https://www.postgresql.org/docs/9.6/static/sql-delete.html > states: > > "The syntax of the RETURNING list is identical to that of the output list > of SELECT." > ​[...]​ > > words=

[GENERAL] Combining INSERT with DELETE RETURNING

2017-03-24 Thread Alexander Farber
Good afternoon, the doc https://www.postgresql.org/docs/9.6/static/sql-delete.html states: "The syntax of the RETURNING list is identical to that of the output list of SELECT." So I am trying to rewrite the INSERT .. ON CONFLICT DO NOTHING followed by a DELETE: INSERT INTO words