On Mon, 04 Mar 2013 16:51:35 -0500
Ryan Johnson wrote:
> On 04/03/2013 2:20 PM, Petite Abeille wrote:
> > On Mar 4, 2013, at 1:32 AM, James K. Lowden
> > wrote:
> >
> >> What do you have in mind? I've benn adding some user defined
> >>
On Tue, 05 Mar 2013 00:26:04 -0500, Igor Tandetnik wrote:
>
> select ID, PostDate, Amount,
> (case when Amount < 0 then -Amount else null end) Withdrawal,(case when
> Amount >= 0 then
> Amount else null end) Deposit,(select sum(Amount) from MyTable t2 where
> t2.ID <= t.ID)
> Balance
Hi all,
given a table
ID integer primary key,
PostDate date,
Amount int
with data
ID PostDateAmount
---
100 2013-01-01 -500
101 2013-01-02 1000
1022013-01-03
Also, You could not rebuild the index from the index, if necessary.
Carlos.
Em 04/03/2013 12:44, Simon Slavin escreveu:
On 4 Mar 2013, at 4:13pm, Eleytherios Stamatogiannakis wrote:
Is there a way in SQLite to have a full covering index on a table without also
storing the
On 04/03/2013 2:20 PM, Petite Abeille wrote:
On Mar 4, 2013, at 1:32 AM, James K. Lowden wrote:
What do you have in mind? I've benn adding some user defined functions
and am thinking of creating a repository for them.
All the so-called window functions from
On Mar 4, 2013, at 1:32 AM, James K. Lowden wrote:
> What do you have in mind? I've benn adding some user defined functions
> and am thinking of creating a repository for them.
All the so-called window functions from SQL:2003 (aka analytic functions):
"Windowed
Hi Richard,
I don't see any mentioning of the optional table argument to the
foreign_key_check pragma in:
http://www.sqlite.org/draft/pragma.html#pragma_foreign_key_check
For example:
SQLite version 3.7.16 2013-03-02 03:25:55
Enter ".help" for instructions
Enter SQL statements terminated with
On 04/03/13 18:44, Simon Slavin wrote:
On 4 Mar 2013, at 4:13pm, Eleytherios Stamatogiannakis wrote:
Is there a way in SQLite to have a full covering index on a table without also
storing the duplicate table?
Can we ask why you care about this ? Do you have a huge table
On 4 Mar 2013, at 4:13pm, Eleytherios Stamatogiannakis wrote:
> Is there a way in SQLite to have a full covering index on a table without
> also storing the duplicate table?
Can we ask why you care about this ? Do you have a huge table which is taking
a huge amount of
Hi,
I have a question:
Is there a way in SQLite to have a full covering index on a table
without also storing the duplicate table?
So if a have a table:
create table t(a,b,c);
and an index covering all its columns:
create index idx_t on t(a,b,c);
SQLite will store everything twice. First
On Sun, Mar 3, 2013 at 2:48 PM, Tom Matrix wrote:
> Hello,
>
> I’ve encountered a problem, which is hardly reproducable on arbitrary
> databases, therefore I attached one.
>
Can you send the database directly to me at d...@sqlite.org please?
> The problem is that inner
On Sun, Mar 3, 2013 at 11:48 AM, Tom Matrix wrote:
> Hello,
>
> I’ve encountered a problem, which is hardly reproducable on arbitrary
> databases, therefore I attached one.
> The problem is that inner join omits the result on large datasets. But
> again, ’large’ does not
Could it be some of the features that SQLite doesn't support?
http://www.sqlite.org/omitted.html
/Patrik
On 03/03/2013 08:48 PM, Tom Matrix wrote:
> Hello,
>
> I’ve encountered a problem, which is hardly reproducable on arbitrary
> databases, therefore I attached one.
> The problem is that
Hello,
I’ve encountered a problem, which is hardly reproducable on arbitrary
databases, therefore I attached one.
The problem is that inner join omits the result on large datasets. But
again, ’large’ does not necessarly refer simply the amount of data; I
couldn’t reproduce it on different
Sorry don't use Linkedin
Charlie
-Original Message-
From: sqlite-users-boun...@sqlite.org
[mailto:sqlite-users-boun...@sqlite.org] On Behalf Of Rajesh Kumar via
LinkedIn
Sent: 04 March 2013 04:44
To: Zarko P.
Subject: [sqlite] Invitation to connect on LinkedIn
LinkedIn
15 matches
Mail list logo