Hi, Dave, Von: Dave Wellman
> The problem deals with dividing by 0. As far as I can remember, in every > programming language that I have ever used and in all databases that I've > used, if you try and divide by 0 the process will fail with a 'divide by > zero' error. Sqlite doesn't seem to do that, it instead returns NULL. AFAIR, there are environments where division by zero for floating points can lead to a +INF or NaN value without an exception. But you're right insofar as the SQL standard seems to mandate an error in this case. http://postgresql.1045698.n5.nabble.com/Division-by-zero-td1922266.html Best regards Markus Schaber CODESYS(r) a trademark of 3S-Smart Software Solutions GmbH Inspiring Automation Solutions 3S-Smart Software Solutions GmbH Dipl.-Inf. Markus Schaber | Product Development Core Technology Memminger Str. 151 | 87439 Kempten | Germany Tel. +49-831-54031-979 | Fax +49-831-54031-50 E-Mail: m.scha...@codesys.com | Web: http://www.codesys.com | CODESYS store: http://store.codesys.com CODESYS forum: http://forum.codesys.com Managing Directors: Dipl.Inf. Dieter Hess, Dipl.Inf. Manfred Werner | Trade register: Kempten HRB 6186 | Tax ID No.: DE 167014915 This e-mail may contain confidential and/or privileged information. If you are not the intended recipient (or have received this e-mail in error) please notify the sender immediately and destroy this e-mail. Any unauthorised copying, disclosure or distribution of the material in this e-mail is strictly forbidden. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users