I know that.
I don't know how postgresql handle this, may be I can check,
I just charring by problem to brainstorm if sqlite may do or not what
postgresql do.
Em 08/03/2013, às 15:06, Israel Lins Albuquerque <israelin...@yahoo.com.br>
escreveu:
> But I see this as a workaround, and not a solution.
> Is that the way I'm using to 'solve' this.
>
> Em 08/03/2013, às 14:11, Michael Black <mdblac...@yahoo.com> escreveu:
>
>> Nobody should expect float comparisons like that to work.
>> If they do they're asking for trouble.
>> All you're seeing is what the database is letting you see. Their "0" is not
>> really "0".
>>
>> Try this in your friendly C compiler
>> main()
>> {
>> double d = 22.35-(5.45+16.9);
>> printf("%f\n",d);
>> printf("%g\n",d);
>> printf("%e\n",d);
>> }
>> On both MS Visual C and gcc on a Linux system:
>> 0.000000
>> 3.55271e-015
>> 3.552714e-015
>>
>> -----Original Message-----
>> From: sqlite-users-boun...@sqlite.org
>> [mailto:sqlite-users-boun...@sqlite.org] On Behalf Of Israel Lins
>> Albuquerque
>> Sent: Thursday, March 07, 2013 12:04 PM
>> To: sqlite-users@sqlite.org
>> Subject: [sqlite] Bug on real operations
>>
>> An example speaks more than words:
>>
>> Execute this:
>> SELECT 22.35 - (5.45 + 16.9), 22.35 = (5.45 + 16.9), (5.45 + 16.9) - 22.35;
>>
>> The expected result on almost databases is:
>> 0.0, true or 1, 0.0
>>
>> But in sqlite for some reason they are:
>> 3.5527136788005e-15, 0, -3.5527136788005e-15
>>
>> I thing this can be a bug on calculation of doubles.
>>
>> Regards,
>> Israel Lins Albuquerque
>> _______________________________________________
>> sqlite-users mailing list
>> sqlite-users@sqlite.org
>> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
>>
>> _______________________________________________
>> sqlite-users mailing list
>> sqlite-users@sqlite.org
>> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
>
> _______________________________________________
> sqlite-users mailing list
> sqlite-users@sqlite.org
> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
