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 'excluded' wording for this?
Couldn't 'new' be used as qualifier instead, akin to trigger syntax?
Might be more coherent, and shorter for the parser.

-- 
Best Regards, Meilleures salutations, Met vriendelijke groeten,
Olivier Mascia


_______________________________________________
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Reply via email to