On May 19, 2009, at 10:05 AM, Jean-Denis Muys wrote:
> On 5/19/09 2:44 PM, "Igor Tandetnik" wrote:
>>
>> Wikipedia gives a definition different from yours, for what it's
>> worth:
>>
>> http://en.wikipedia.org/wiki/Remainder#The_case_of_general_integers
>
> Also to support my version, the same
On 5/19/09 2:44 PM, "Igor Tandetnik" wrote:
>
> Wikipedia gives a definition different from yours, for what it's worth:
>
> http://en.wikipedia.org/wiki/Remainder#The_case_of_general_integers
Also to support my version, the same article says a bit later:
" Usually, in number theory, we alwa
On 5/19/09 2:44 PM, "Igor Tandetnik" wrote:
>
> Well then, for the equality to hold, (-1)/7 should be -1. Would you be
> happy with such an outcome?
>
Yep
> Wikipedia gives a definition different from yours, for what it's worth:
>
> http://en.wikipedia.org/wiki/Remainder#The_case_of_general_
On 19/05/2009 9:57 PM, Igor Tandetnik wrote:
> "John Machin" wrote
> in message news:4a129cb4.2090...@lexicon.net
>> It's handy for checking how things work e.g.
>>
>> sqlite> select (-1) % 7;
>> -1
>> sqlite> -- it's not a real modulo operator :-(
>
> What do you feel is wrong with this result?
On Tue, May 19, 2009 at 02:06:37PM +0200, Jean-Denis Muys wrote:
>
> There exists unique natural numbers q and r such as:
>
> a = b*q+r
> 0 <= r < b
>
> q is defined as the quotient, r is defined as the remainder.
>
> So if the % operator wants to match that math definition, its results should
"Jean-Denis Muys"
wrote in message news:c6386d6d.45a7%jdm...@kleegroup.com
> On 5/19/09 1:57 PM, "Igor Tandetnik"
> wrote:
>
>> "John Machin"
>> wrote in message
>> news:4a129cb4.2090...@lexicon.net
>>> It's handy for checking how things work e.g.
>>>
>>> sqlite> select (-1) % 7;
>>> -1
>>> sqli
On Tue, May 19, 2009 at 12:49 PM, John Machin wrote:
> It's handy for checking how things work e.g.
>
> sqlite> select (-1) % 7;
> -1
> sqlite> -- it's not a real modulo operator :-(
I also used it as:
sqlite> .mode col
sqlite> .h 1
sqlite> select "€", length("€"), length(cast("€" as blob)), hex
My memory failed me on a detail if I want to be rigorous. In the definition
of q and r, r is a natural number, but q is a relative number, not a
natural.
On 5/19/09 2:06 PM, "Jean-Denis Muys" wrote:
> On 5/19/09 1:57 PM, "Igor Tandetnik" wrote:
>
>> "John Machin" wrote
>> in message news:4a1
On 5/19/09 1:57 PM, "Igor Tandetnik" wrote:
> "John Machin" wrote
> in message news:4a129cb4.2090...@lexicon.net
>> It's handy for checking how things work e.g.
>>
>> sqlite> select (-1) % 7;
>> -1
>> sqlite> -- it's not a real modulo operator :-(
>
> What do you feel is wrong with this result
"John Machin" wrote
in message news:4a129cb4.2090...@lexicon.net
> It's handy for checking how things work e.g.
>
> sqlite> select (-1) % 7;
> -1
> sqlite> -- it's not a real modulo operator :-(
What do you feel is wrong with this result? What should a "real" modulo
operator return, in your opin
On 19/05/2009 9:37 PM, Nuno Lucas wrote:
> On Mon, May 18, 2009 at 5:03 PM, Mitchell L Model wrote:
>> I may be misreading the select-core diagram on
>> http://www.sqlite.org/lang_select.html but it appears that the down-arrow
>> that would allow a query without a FROM clause should not be ther
On Mon, May 18, 2009 at 5:03 PM, Mitchell L Model wrote:
> I may be misreading the select-core diagram on
> http://www.sqlite.org/lang_select.html but it appears that the down-arrow
> that would allow a query without a FROM clause should not be there. Is it
> really possible to have a SELECT w
I may be misreading the select-core diagram on
http://www.sqlite.org/lang_select.html but it appears that the down-arrow that
would allow a query without a FROM clause should not be there. Is it really
possible to have a SELECT with no FROM? If so, could someone provide an
example; if not, wou
On May 18, 2009, at 2:53 PM, Pavel Ivanov wrote:
> Actually I wanted to know if it can be useful somewhere. :-)
I already shown you one useful thing to do with a SELECT that omits
the FROM clause: Determine the version of SQLite you are running
using "SELECT sqlite_version()".
In applicat
--Original Message-
>> From: sqlite-users-boun...@sqlite.org
>> [mailto:sqlite-users-boun...@sqlite.org] On Behalf Of Pavel Ivanov
>> Sent: Monday, May 18, 2009 11:37 AM
>> To: General Discussion of SQLite Database
>> Subject: Re: [sqlite] error in documentation of
order by 1
>
> Noah
>
> -Original Message-
> From: sqlite-users-boun...@sqlite.org
> [mailto:sqlite-users-boun...@sqlite.org] On Behalf Of Pavel Ivanov
> Sent: Monday, May 18, 2009 11:37 AM
> To: General Discussion of SQLite Database
> Subject: Re: [sqlite] error in doc
vel Ivanov
Sent: Monday, May 18, 2009 11:37 AM
To: General Discussion of SQLite Database
Subject: Re: [sqlite] error in documentation of SELECT?
I didn't notice it earlier and now I'm a bit surprised. Can I ask a
more elaborate example which will include WHERE and/or GROUP BY but
not in
I didn't notice it earlier and now I'm a bit surprised. Can I ask a
more elaborate example which will include WHERE and/or GROUP BY but
not include FROM?
Pavel
On Mon, May 18, 2009 at 2:32 PM, D. Richard Hipp wrote:
>
> On May 18, 2009, at 2:18 PM, Mitchell L Model wrote:
>
>> Is it really possi
On May 18, 2009, at 2:18 PM, Mitchell L Model wrote:
> Is it really possible to have a SELECT with no FROM? If so, could
> someone provide an example; i
SELECT sqlite_version();
D. Richard Hipp
d...@hwaci.com
___
sqlite-users mailing list
sqlite-
I may be misreading the select-core diagram on
http://www.sqlite.org/lang_select.html but it appears that the down-arrow that
would allow a query without a FROM clause should not be there. Is it really
possible to have a SELECT with no FROM? If so, could someone provide an
example; if not, wou
20 matches
Mail list logo