On 6 May 2013, at 11:48pm, skywind mailing lists <mailingli...@skywind.eu> wrote:
> How do I create this kind of update statement? > > UPDATE T SET a=0.5*(a+b), b=0.5*(b-a); > > The RHS should always be used with the values of a and b before the > assignment. > > I think that the result of this kind of statement is undefined, or? No need to worry, it will work the way you want it to work: The row is read. The new values are calculated. The new values are written to the database. This is standard in all SQL implementations. Simon. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
