Re: [sqlite] Break on cumulative sum

2013-03-04 Thread James K. Lowden
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 > >>

Re: [sqlite] More noobie questions

2013-03-04 Thread Kai Peters
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

[sqlite] More noobie questions

2013-03-04 Thread Kai Peters
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

Re: [sqlite] Full covering index without table

2013-03-04 Thread Carlos Milon Silva
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

Re: [sqlite] Break on cumulative sum

2013-03-04 Thread Ryan Johnson
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

Re: [sqlite] Break on cumulative sum

2013-03-04 Thread Petite Abeille
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

Re: [sqlite] SQLite 3.7.16 beta

2013-03-04 Thread Levi Haskell (BLOOMBERG/ 731 LEXIN)
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

Re: [sqlite] Full covering index without table

2013-03-04 Thread Eleytherios Stamatogiannakis
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

Re: [sqlite] Full covering index without table

2013-03-04 Thread Simon Slavin
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

[sqlite] Full covering index without table

2013-03-04 Thread Eleytherios Stamatogiannakis
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

Re: [sqlite] inner vs. outer join inconsistency

2013-03-04 Thread Richard Hipp
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

Re: [sqlite] inner vs. outer join inconsistency

2013-03-04 Thread Pavel Ivanov
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

Re: [sqlite] inner vs. outer join inconsistency

2013-03-04 Thread Patrik Nilsson
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

[sqlite] inner vs. outer join inconsistency

2013-03-04 Thread Tom Matrix
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

Re: [sqlite] Invitation to connect on LinkedIn

2013-03-04 Thread chas cartmel
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