On Wed, Jan 23, 2008 at 3:23 PM, James Dennett
<[EMAIL PROTECTED]> wrote:
> The POSIX/Single Unix Spec documentation for fnmatch might be a good
> source, but I agree with the idea that SQLite should just document what
> it does rather than assuming that there's a universal standard for
>
I have been trying to implement the paradigm of using Triggers to emulate
referential integrity, for example cascading updates and
deletes between two database tables. This works when the two database tables
are in “main” but when I try to create the triggers
between database tables in
"Alexander Batyrshin" <[EMAIL PROTECTED]> wrote:
> Hello All,
> I've found that SQLite-3.5.4 doesnt use index in this situation:
>
> sqlite> create table t1 (id int primary key, val int);
> sqlite> create table t2 (id unique, val int primary key);
> sqlite> explain query plan update t1 set val =
Ken wrote:
I'm not sure if this a bug or if working as intended:
the order by b,a seems to cause B to use asc.. Instead of the desc as written in the order by statement.
create table tst (a integer, b integer );
sqlite> insert into tst values(1,1);
sqlite> insert into tst values(1,2);
Ken wrote:
the order by b,a seems to cause B to use asc.. Instead of the desc as written in the order by statement.
Ken,
You would need to say
order by b desc, a desc
to get the behaviour you expect.
HTH
Dennis Cote
Unless I don't know SQL, the results look correct. Anyone chime in to
correct me.
Your query:
select * from tst order by b, a desc;
Is really:
select * from tst order by b ASC, a desc;
So, if you look at the rows from top to bottom, you'll see that for each
value of 'b' in ascending order, you
> -Original Message-
> From: Ken [mailto:[EMAIL PROTECTED]
> Sent: Wednesday, January 23, 2008 4:10 PM
> To: sqlite
> Subject: [sqlite] order by issue?
>
> I'm not sure if this a bug or if working as intended:
>
> the order by b,a seems to cause B to use asc.. Instead of the desc as
>
James Dennett wrote:
The POSIX/Single Unix Spec documentation for fnmatch might be a good
source, but I agree with the idea that SQLite should just document what
it does rather than assuming that there's a universal standard for
globbing.
I think the most direct documentation I have found so
I'm not sure if this a bug or if working as intended:
the order by b,a seems to cause B to use asc.. Instead of the desc as written
in the order by statement.
create table tst (a integer, b integer );
sqlite> insert into tst values(1,1);
sqlite> insert into tst values(1,2);
sqlite> insert
Hi All,
I already had the sqlite library for 32 bits as libsqlite3.so.0.86 and now I
want to build the sqlite library for 64bits for 64bits machine. Can someone
help me with the information how to build the sqlite library which is used for
64bits machine.
Thanks in advance for your help.
JP
> -Original Message-
> From: Dennis Cote [mailto:[EMAIL PROTECTED]
> Sent: Wednesday, January 23, 2008 3:08 PM
> To: sqlite-users@sqlite.org
> Subject: Re: [sqlite] Query problem
>
> James Dennett wrote:
> >
> > Square brackets don't "escape" thing that way: [[] is a character
class
> >
James Dennett wrote:
Square brackets don't "escape" thing that way: [[] is a character class
containing only the character '['. [][], however, is a character class
containing two characters. The special rule is that the first character
after the opening '[' is part of the class even if it's a
"Alexander Batyrshin" <[EMAIL PROTECTED]> wrote:
> On Jan 21, 2008 12:58 AM, Alexander Batyrshin <[EMAIL PROTECTED]> wrote:
> > On Jan 20, 2008 11:32 PM, <[EMAIL PROTECTED]> wrote:
> > > "Alexander Batyrshin" <[EMAIL PROTECTED]> wrote:
> > > > Hello everyone.
> > > > I've discover performance
[EMAIL PROTECTED] wrote:
Experiments using bash indicate that either ^ or ! is accepted
as the negation of a character set. Hence,
ls -d [^tu]*
ls -d [!tu]*
both return the same thing - a list of all files and directories
in the current directory whose names do not begin with "t" or
> -Original Message-
> From: Dennis Cote [mailto:[EMAIL PROTECTED]
> Sent: Wednesday, January 23, 2008 2:22 PM
> To: sqlite-users@sqlite.org
> Subject: Re: [sqlite] Query problem
>
> [EMAIL PROTECTED] wrote:
> >
> > You
> > can escape characters using [..]. To match a * anywhere in a
[EMAIL PROTECTED] wrote:
[EMAIL PROTECTED] wrote:
This appears to be slightly different than normal *nix globbing since
SQLite uses '^' rather than '!' for the set inversion (if my reading of
the source is correct).
GLOB is suppose to exactly mimic Unix, except that SQLite does not
break
sqlite> select datetime('1201561222', 'unixepoch');
2008-01-28 23:00:22
OK, so now it's clear your values are Unix times.
sqlite> select strftime('%s', date('1201561222', 'unixepoch'));
1201478400
Effectively strips the time portion of your time value
sqlite> select datetime('1201478400',
[EMAIL PROTECTED] wrote:
You
can escape characters using [..]. To match a * anywhere in a string,
for example:
x GLOB '*[*]*'
The [..] pattern must contain at least one internal character. So
to match a "]" you can use the pattern
x GLOB '*[]]*'
So to match the OP's original string he would
Joanne Pham wrote:
Any help for this question please!
I would like to convert from t1 to t2.
and my table is store t2.
t1: 201561222 -> 2008-01-28 15:00:22
and I want
t2 ?-> 2008-01-28 00:00:00
I think your numbers got cutoff... you mean 1201561222 right? Anyway
try this:
On Jan 21, 2008 12:58 AM, Alexander Batyrshin <[EMAIL PROTECTED]> wrote:
> On Jan 20, 2008 11:32 PM, <[EMAIL PROTECTED]> wrote:
> > "Alexander Batyrshin" <[EMAIL PROTECTED]> wrote:
> > > Hello everyone.
> > > I've discover performance degradation due to update 3.3.17 -> 3.5.4.
> > > This SQL
Any help for this question please!
I would like to convert from t1 to t2.
and my table is store t2.
t1: 201561222 -> 2008-01-28 15:00:22
and I want
t2 ?-> 2008-01-28 00:00:00
Thanks
JP
- Original Message
From: Joanne Pham <[EMAIL PROTECTED]>
To:
DRH wrote:
>
> Experiments using bash indicate that either ^ or ! is accepted
> as the negation of a character set. Hence,
>
> ls -d [^tu]*
> ls -d [!tu]*
>
> both return the same thing - a list of all files and directories
> in the current directory whose names do not begin with "t"
[EMAIL PROTECTED] wrote:
>
> > This appears to be slightly different than normal *nix globbing since
> > SQLite uses '^' rather than '!' for the set inversion (if my reading of
> > the source is correct).
>
> GLOB is suppose to exactly mimic Unix, except that SQLite does not
> break pattern
"Mark Riehl" <[EMAIL PROTECTED]> wrote:
> I'm working with version 3.5.2 under Linux. I've got a database that
> is being shared between two processes and I'm running into issues with
> the journal file that doesn't go away. When that happens, one process
> appears to have the lock on the
On Jan 23, 2008 7:54 AM, Dennis Cote <[EMAIL PROTECTED]> wrote:
> Robert Wishlaw wrote:
> > When .import parses an empty field in the csv file, that is , a comma
> > immediately followed by another comma, is the cell, in the database,
> > that corresponds to the empty field a NULL cell?
> >
>
I'm working with version 3.5.2 under Linux. I've got a database that
is being shared between two processes and I'm running into issues with
the journal file that doesn't go away. When that happens, one process
appears to have the lock on the database and the other process is
essentially locked
Joanne Pham wrote:
Thank Ken,
But this is not what I want. I would like to truncate the hour.
So
t1: 201561222 -> 2008-01-28 15:00:22
and I want
t2 ? -> 2008-01-28 00:00:00
So I want to find out t2? which has no hour number.
So you just want the date (i.e. No time at all)?
Thank Ken,
But this is not what I want. I would like to truncate the hour.
So
t1: 201561222 -> 2008-01-28 15:00:22
and I want
t2 ? -> 2008-01-28 00:00:00
So I want to find out t2? which has no hour number.
Thanks
JP
- Original Message
From: Ken <[EMAIL PROTECTED]>
To:
assuming your time is in seconds.
try
t1: 201561222 -> 2008-01-28 15:00:22
and you want
t2: 1201561200 -> 2008-01-28 15:00:00
t1 = t2 - (t2 mod 3600)
Joanne Pham <[EMAIL PROTECTED]> wrote: Hi All,
I have a hour table which has the startTime are stored at GMT time. The
Hi All,
I have a hour table which has the startTime are stored at GMT time. The
startTime of this hour table has the values below:
Hour table
---
StartTimeequivalent with the time format
1201561200 -> 2008-01-28 15:00:00
120159 -> 2008-01-28 23:00:00
120159
Dennis Cote <[EMAIL PROTECTED]> wrote:
>>
> SQLite seems to do the following:
>
> The glob syntax supports the following patterns:
> ? - matches any single character
> * - matches zero or more characters
> [seq] - matches any single character in seq
> [!seq] - matches any
Thanks for the quick answers.
Pierre8r
-
To unsubscribe, send email to [EMAIL PROTECTED]
-
Pierre8r <[EMAIL PROTECTED]> wrote:
One SQLite database on my PC.
Two softwares.
May one software write to the SQLite database while a other read the
same SQLite database ?
Not at the exact same time. The database file is essentially protected
by multiple-readers-single-writer lock. But the
Pierre8r <[EMAIL PROTECTED]> wrote:
> Hello,
>
> One SQLite database on my PC.
> Two softwares.
> May one software write to the SQLite database while a other read the
> same SQLite database ?
>
Your programs cannot be reading and writing at exactly the
same instant in time. But both programs
Yasir Nisar wrote:
Hi,
Hope you will find this mail in the best of your health.
SELECT * FROM BackupTable,BackupItemTable,BackItUpPathTable WHERE lower(BackItUpPathTable.WinName) GLOB lower("*1[]1.txt*") AND BackupItemTable.BKItemSize > -1 AND BackupTable.BackupNo =
Hello,
One SQLite database on my PC.
Two softwares.
May one software write to the SQLite database while a other read the
same SQLite database ?
Thanks,
Pierre8r
-
To unsubscribe, send email to [EMAIL PROTECTED]
Robert Wishlaw wrote:
When .import parses an empty field in the csv file, that is , a comma
immediately followed by another comma, is the cell, in the database,
that corresponds to the empty field a NULL cell?
Robert,
No, it inserts a text field containing an empty string.
All the fields
Ciao, a tutti! il giorno lunedì 21 gennaio 2008 parlavamo "Re: [sqlite]
Strange error "Incomplete SQL""
> Do you really need to use version 2.8.17?
it's just the default version present in opensuse, I'm just a noob of sqlite
(it's the first time I used it) and I'm just "playing" with the cli
You need single quotes for text literals.
On Jan 23, 2008 6:15 AM, Yasir Nisar <[EMAIL PROTECTED]> wrote:
> SELECT * FROM BackupTable,BackupItemTable,BackItUpPathTable WHERE
> lower(BackItUpPathTable.WinName) GLOB lower("*1[]1.txt*") AND
> BackupItemTable.BKItemSize > -1 AND
"Mina R Waheeb" <[EMAIL PROTECTED]> wrote:
> Hi,
>I have few questions regarding the limitation of multiple databases with
> SQLite.
>
> I have a large number of SQLite DB files with the same structure i
> need to query them all (looking for speed), I have tried ATTACH method
> and its
Hi,
Hope you will find this mail in the best of your health.
SELECT * FROM BackupTable,BackupItemTable,BackItUpPathTable WHERE
lower(BackItUpPathTable.WinName) GLOB lower("*1[]1.txt*") AND
BackupItemTable.BKItemSize > -1 AND BackupTable.BackupNo =
BackupItemTable.BackupNo AND
41 matches
Mail list logo