On Thu, 11 Apr 2019 11:35:04 +1000 John McMahon <li...@jspect.fastmail.fm> wrote:
> > SELECT x * y & ~1 AS even_numbered_area FROM squares; > > Suggestion: "Don't Do That", use database purely as a storage medium. You yourself don't really believe that! A disk is a storage medium. A file is an undifferntiated stream of bytes. A SQLite database is much more than that, as I'm sure you'll agree. Not least, it includes a query language with a passing resemblance to first order predicate logic and set theory. > You would seem to be working in an edge case environment, in which > case it is your responsibility to make the adjustments. Actually, the OP was illustrating how implicit conversion to double yields incorrect results instead of a domain error. I somehow doubt he has much use for 10^80 on a regular basis. --jkl _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
