On 13 Jun 2019, at 11:08pm, Keith Medcalf <kmedc...@dessus.com> wrote:
> Note that even when the column is declared with no affinity that NaNs are > stored as null. Other than NaN, all other IEEE754 double values (including > subnormals and +/- Inf) seem to round-trip correctly through the bind_double > and column_double interface ... Just to round this off, IEEE754 has two different NaN values: signalling and non-signalling. SQLite doesn't distinguish between them. _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
