On 6 Nov 2015, at 2:20pm, Wade, William wrote:
> I have an engineering application, where double can be part of a key.
So do I, using Longitude and Latitude in GPS coordinates. A lot of things done
inside GPS devices amount to "List everything in this rectangle".
This is the problem. Theore
ing those (I think the sqlite numeric
types are all representable as bigint rationals). That may be overkill (and not
all that lite).
Regards
-Original Message-
From: Richard Hipp [mailto:d...@sqlite.org]
Sent: Thursday, November 05, 2015 8:55 AM
To: SQLite mailing list
Subject: Re: [sqli
On 11/6/2015 9:20 AM, Wade, William wrote:
> However I do depend on getting consistent answers, and on (x >= 1234) being
> disjoint from (x < 1234) and that those two ranges cover the number line. I
> suspect that sqlite makes that kind of guarantee, at least if I explicitly
> cast values to dou
On 2015/11/05 4:55 PM, Richard Hipp wrote:
> On 11/5/15, Zsb?n Ambrus wrote:
>> Dear SQLite,
>>
>> It seems that equality of numeric values isn't transitive, when both
>> integers and reals are involved. Here's an example output from the
>> shell, which shows that the numeric value in the 'c' r
On Thu, Nov 5, 2015 at 3:36 PM, Zsb?n Ambrus wrote:
> It seems that equality of numeric values isn't transitive, when both
> integers and reals are involved.
See this really, really, really, really long thread on that topic from a
couple weeks ago for far, far, far more information than you cou
Dear SQLite,
It seems that equality of numeric values isn't transitive, when both
integers and reals are involved. Here's an example output from the
shell, which shows that the numeric value in the 'c' row is equal to
both the value in the 'b' and the 'd' rows, but the value in the 'b'
row isn't
On 11/5/15, Zsb?n Ambrus wrote:
> Dear SQLite,
>
> It seems that equality of numeric values isn't transitive, when both
> integers and reals are involved. Here's an example output from the
> shell, which shows that the numeric value in the 'c' row is equal to
> both the value in the 'b' and the '
7 matches
Mail list logo