Re: [sqlite] 3.24 draft - upsert

2018-05-09 Thread Jim Callahan
riginal 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 > > > >On 5/9/18,

Re: [sqlite] 3.24 draft - upsert

2018-05-09 Thread Keith Medcalf
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 > >On 5/9/18, Olivier Mascia wrote: >> About: >> >> "Column names in the expressions of a DO UPDATE refer to the &g

Re: [sqlite] 3.24 draft - upsert

2018-05-09 Thread Roman Fleysher
Why does SQLite have to follow what PostgreSQL does? I thought SQLite is the leader. Roman Sent from my T-Mobile 4G LTE Device Original message From: Richard Hipp Date: 5/9/18 5:48 AM (GMT-05:00) To: SQLite mailing list Subject: Re: [sqlite] 3.24 draft - upsert On 5/9

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 constraint not failed,

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 special >> "excluded."

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 constraint not failed, a

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 > "excluded." table qual

[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 'exc