On Fri, 14 Jun 2019 at 3:28 am, Doug <[email protected]> wrote: > It occurs to me that if there are sqlite applications today requiring the > functionality of -0.0, they have implemented it so that it works for their > application. Perhaps, they accomplished that by adding a flag bit or by > some other means. > > So if you do nothing about -0.0, you will break no existing applications. > Granted, you are not adhering to IEEE-745. > > However, ... > > If you can find anyone who has implemented such an application (using > -0.0), you could find out how they implemented it. To make sqlite adhere to > IEEE-745, generate an sqlite application note suggesting possible ways an > application might implement the functionality.
My application uses it as we are required to maintain a bit perfect copy of customer data. As such we had to store it as a BLOB with extra logic around converting it back to a C double on retrieval. Given there's been numerous comments to the effect that SQLite now supports -0.0 storing and retrieval other than printing, I'm curious which version this was implemented in as I wouldn't mind removing my custom code when we move to a SQLite version with this improvement. Regards, Donald Shepherd. _______________________________________________ sqlite-users mailing list [email protected] http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
