S, Igor Tandetnik piše: > Radovan Antloga<radovan.antl...@siol.net> wrote: >> create table test (a integer not null, b float not null); >> >> update test >> set b = 0.0 / 0; >> >> you will get error: test.b may not be null > Appears to be working as intended. Division by zero produces null, which > cannot be stored in test.b . What exactly seems to be the problem?
Oh I see sqlite allows division by zero but result is null. Sorry I didn't expect it. Some other DB gives division by zero error in this case. But actually I like sqlite way more. I will fix some of my sql-s to use this sqlite feature :-). _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
