On 2014/02/28 23:36, L. Wood wrote:
SQLite has the REAL data type:
https://www.sqlite.org/datatype3.html
Then why do we have SQLITE_FLOAT instead of SQLITE_REAL? All the other data
types (INTEGER, BLOB, TEXT, NULL) match with the SQLITE_ constants.
Quoting Shakespeare's Juliet:
What's in a
On 3/1/2014, 12:16 AM, RSmith wrote:
On 2014/02/28 23:36, L. Wood wrote:
SQLite has the REAL data type:
https://www.sqlite.org/datatype3.html
Then why do we have SQLITE_FLOAT instead of SQLITE_REAL? All the other data
types (INTEGER, BLOB, TEXT, NULL) match with the SQLITE_ constants.
On Fri, Feb 28, 2014 at 10:14 PM, Dominique Devienne
ddevie...@gmail.com wrote:
Can someone tell me how the statement below works?
Thanks for any help on this. This is really puzzling to me. --DD
Very puzzling for me too
For any statement like this
select * from blablabla(123)
On 2014/03/01 10:32, Darren Duncan wrote:
If you're going by semantics though, the meanings are quite different.
A real number represents a point on a line and can be either a rational or irrational number. (And a complex number is a point on
a plane.) An important bit is that a real is a
Please excuse me for not explaining.
The syntax that you puzzle about is supported by madIS [*] which
translates it into SQLite. Having being using madIS for many years (we
created it in 2008) it comes natural to me, forgetting that SQLite
doesn't support it.
What essentially madIS does is
i compile sqlite 3.8.3 to vxworks 6.9, i first compile sqlite in dkm and
get xx.a lib file, and then test it in vip project, but meet disk i/o error,
can you help me ? thank you , my email is del...@126.com
--
View this message in context:
i compile sqlite 3.8.3 to vxworks 6.9, i first compile sqlite in dkm and
get xx.a lib file, and then test it in vip project, but meet disk i/o error,
can you help me ? thank you , my email is del...@126.com
--
View this message in context:
Just because we can:
with
Option( name, position )
as
(
select sqlite_compileoption_get( 1 ) as name,
1 as position
union all
select sqlite_compileoption_get( position + 1 ) as name,
position + 1 as position
fromOption
where sqlite_compileoption_get(
Hello,
? PRAGMA compile_options;
Best Regards.
On Sat, Mar 1, 2014 at 7:01 AM, Petite Abeille petite.abei...@gmail.comwrote:
Just because we can:
with
Option( name, position )
as
(
select sqlite_compileoption_get( 1 ) as name,
1 as position
union all
select
Hello,
Sqlite 3.8.3 implemented recursive CTE.
Sqlite 3.8.4 is shaping to be another great tuning/optimisation release.
Would it be possible to get a small basic subset of the sql windowing
function for Sqlite 3.8.5 ?
If we imagine that the basic windowing is a bit like a CTE 'rewording', it
You are missing one value. To get all the values, start from 0:
with
Option( name, position )
as
(
select sqlite_compileoption_get( 0 ) as name,
0 as position
union all
select sqlite_compileoption_get( position + 1 ) as name,
position + 1 as position
fromOption
On Mar 1, 2014, at 7:46 PM, Bogdan Ureche bogdan...@gmail.com wrote:
You are missing one value. To get all the values, start from 0:
At least someone is paying attention! Thanks :)
___
sqlite-users mailing list
sqlite-users@sqlite.org
On Mar 1, 2014, at 6:30 PM, mm.w 0xcafef...@gmail.com wrote:
? PRAGMA compile_options;
Yes, sure. But much snazzier to use a CTE, no? :D
( One very unfortunate aspect of pragmas is that one cannot query them with
regular SQL… sigh…)
___
On Mar 1, 2014, at 7:39 PM, big stone stonebi...@gmail.com wrote:
Would it be possible to get a small basic subset of the sql windowing
function for Sqlite 3.8.5 ?
Yes! Pretty please :)
Supporting windowing functions (aka analytics) would be a major breakthrough.
Hello
you meant that's for the Buzz 8) (joke inside)
Best Regards
On Sat, Mar 1, 2014 at 11:06 AM, Petite Abeille petite.abei...@gmail.comwrote:
On Mar 1, 2014, at 6:30 PM, mm.w 0xcafef...@gmail.com wrote:
? PRAGMA compile_options;
Yes, sure. But much snazzier to use a CTE, no? :D
(
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On 28/02/14 06:37, deltuo wrote:
i compile sqlite 3.8.3 to vxworks 6.9, i first compile sqlite in dkm
and get xx.a lib file, and then test it in vip project, but meet disk
i/o error, can you help me ? thank you , my email is del...@126.com
On Sat, Mar 1, 2014 at 8:02 PM, Petite Abeille petite.abei...@gmail.comwrote:
On Mar 1, 2014, at 7:46 PM, Bogdan Ureche bogdan...@gmail.com wrote:
You are missing one value. To get all the values, start from 0:
At least someone is paying attention! Thanks :)
Strangely enough, starting at
On Mar 1, 2014, at 9:34 PM, Stephan Beal sgb...@googlemail.com wrote:
note the duplicate first entry.
Make sure to start everything at zero:
select sqlite_compileoption_get( 0 ) as name,
0 as position
___
sqlite-users mailing list
Great, thanks!
2014-02-26 0:11 GMT-03:00 Richard Hipp-3 [via SQLite]
ml-node+s1065341n74140...@n5.nabble.com:
On Tue, Feb 25, 2014 at 1:11 PM, nobre [hidden
email]http://user/SendEmail.jtp?type=nodenode=74140i=0
wrote:
Hi! Given this schema:
create table q (id integer primary key,
Hi,
thanks for explaining your syntax in another post. Now about virtual
tables if you don't mind.
On Fri, Feb 28, 2014 at 8:24 PM, Eleytherios Stamatogiannakis
est...@gmail.com wrote:
If we load into SQLite,
create table newtable as select * from READCOMPRESSEDFILE('ctable.rc');
it
20 matches
Mail list logo