Re: [sqlite] Calculation between rows?

On 7/17/05, Darren Duncan <[EMAIL PROTECTED]> wrote: > Assuming there actually is a meta-data function like ROW_NUMBER(), > which is the ordinal value of the row in the query result, you can > just do something like this: > > SELECT > FROM ( >SELECT ROW_NUMBER() AS myrownum, sq.* >FROM

[sqlite] Calculation between rows?

I have a simple data acquisition application that reads a byte counter and records it in an sqlite3 table. The table is defined as: create table data (timestamp, bytecount); The 'timestamp' field is the output of the standard c-library seconds-since-the-epoch time() function and the 'bytecount'

[sqlite] sqlite3-3.1.2.bin segfault

I've got a linux 2.4.26 box here running a Knoppix 3.4 distro installed on the hard drive. I've downloaded http://sqlite.org/sqlite3-3.1.2.bin.gz, gunzip'ed it, chmod'ed it to 755 and renamed the .bin to sqlite3. When I run it it segfaults. Since this is a static executable I'm wondering if

Re: [sqlite] New Mailing List: List-Id Header

D. Richard Hipp wrote: > William Trenker wrote: > > > > Any chance of adding the standard List-Id header to the new mailing list? > > If I made the change correctly, this reply should have the List-Id header line. > Thanks for the quick

[sqlite] New Mailing List: List-Id Header

(Sorry if this comes through twice. I changed email addresses when I changed to the new sqlite list and got things confused on my end. All is fixed now.) Any chance of adding the standard List-Id header to the new mailing list? This header is handy for filtering messages and some email