Re: [sqlite] 3.24 draft - upsert

2018-05-09 Thread Jim Callahan
; >-Original Message- > >From: sqlite-users [mailto:sqlite-users- > >boun...@mailinglists.sqlite.org] On Behalf Of Richard Hipp > >Sent: Wednesday, 9 May, 2018 03:48 > >To: SQLite mailing list > >Subject: Re: [sqlite] 3.24 draft - upsert > >

Re: [sqlite] 3.24 draft - upsert

2018-05-09 Thread Keith Medcalf
qlite.org] On Behalf Of Richard Hipp >Sent: Wednesday, 9 May, 2018 03:48 >To: SQLite mailing list >Subject: Re: [sqlite] 3.24 draft - upsert > >On 5/9/18, Olivier Mascia <o...@integral.be> wrote: >> About: >> >> "Column names in the expressions of

Re: [sqlite] 3.24 draft - upsert

2018-05-09 Thread Roman Fleysher
ite-users@mailinglists.sqlite.org> Subject: Re: [sqlite] 3.24 draft - upsert On 5/9/18, Olivier Mascia <o...@integral.be> wrote: > About: > > "Column names in the expressions of a DO UPDATE refer to the original > unchanged value of the column, before the attempted INSERT. To use the value

Re: [sqlite] 3.24 draft - upsert

2018-05-09 Thread Seiji Amalai
Fuck you suck On Wed, 9 May 2018, 09:00 Olivier Mascia, wrote: > About: > > "Column names in the expressions of a DO UPDATE refer to the original > unchanged value of the column, before the attempted INSERT. To use the > value that would have been inserted had the

Re: [sqlite] 3.24 draft - upsert

2018-05-09 Thread Olivier Mascia
> Le 9 mai 2018 à 11:48, Richard Hipp a écrit : > >> "Column names in the expressions of a DO UPDATE refer to the original >> unchanged value of the column, before the attempted INSERT. To use the value >> that would have been inserted had the constraint not failed, add the

Re: [sqlite] 3.24 draft - upsert

2018-05-09 Thread R Smith
On 2018/05/09 11:48 AM, Richard Hipp wrote: On 5/9/18, Olivier Mascia wrote: About: "Column names in the expressions of a DO UPDATE refer to the original unchanged value of the column, before the attempted INSERT. To use the value that would have been inserted had the

Re: [sqlite] 3.24 draft - upsert

2018-05-09 Thread Richard Hipp
On 5/9/18, Olivier Mascia wrote: > About: > > "Column names in the expressions of a DO UPDATE refer to the original > unchanged value of the column, before the attempted INSERT. To use the value > that would have been inserted had the constraint not failed, add the special >

[sqlite] 3.24 draft - upsert

2018-05-09 Thread Olivier Mascia
About: "Column names in the expressions of a DO UPDATE refer to the original unchanged value of the column, before the attempted INSERT. To use the value that would have been inserted had the constraint not failed, add the special "excluded." table qualifier to the column name." Why using