Hi, 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? Regards, Hartwig _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

