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,
On Mon, May 18, 2009 at 5:03 PM, Mitchell L Model m...@acm.org 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
On 19/05/2009 9:37 PM, Nuno Lucas wrote:
On Mon, May 18, 2009 at 5:03 PM, Mitchell L Model m...@acm.org 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
John Machin sjmac...@lexicon.net 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
On 5/19/09 1:57 PM, Igor Tandetnik itandet...@mvps.org wrote:
John Machin sjmac...@lexicon.net 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
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 jdm...@kleegroup.com wrote:
On 5/19/09 1:57 PM, Igor Tandetnik itandet...@mvps.org wrote:
John Machin
On Tue, May 19, 2009 at 12:49 PM, John Machin sjmac...@lexicon.net 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
Jean-Denis Muys jdm...@kleegroup.com
wrote in message news:c6386d6d.45a7%jdm...@kleegroup.com
On 5/19/09 1:57 PM, Igor Tandetnik
itandet...@mvps.org wrote:
John Machin sjmac...@lexicon.net
wrote in message
news:4a129cb4.2090...@lexicon.net
It's handy for checking how things work e.g.
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
never be
On 19/05/2009 9:57 PM, Igor Tandetnik wrote:
John Machin sjmac...@lexicon.net 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
On 5/19/09 2:44 PM, Igor Tandetnik itandet...@mvps.org 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:
On 5/19/09 2:44 PM, Igor Tandetnik itandet...@mvps.org 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
On May 19, 2009, at 10:05 AM, Jean-Denis Muys wrote:
On 5/19/09 2:44 PM, Igor Tandetnik itandet...@mvps.org 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
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,
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
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 d...@hwaci.com wrote:
On May 18, 2009, at 2:18 PM, Mitchell L Model wrote:
Is it
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 include FROM?
Pavel
CONFIDENTIALITY
-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 SELECT?
I didn't notice it earlier and now
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
19 matches
Mail list logo