Re: [sqlite] any way to SELECT the 100th-104th row of a table?

2007-10-07 Thread Peter Bierman
At 3:00 PM -0700 10/7/07, Adam Megacz wrote: Hello. This is probably a stupid question, but... Is there any way to include some phrase in a SELECT clause that will match only the Nth-Mth rows of a table, for some values of N and M? Note that ROWID isn't what I'm looking for -- if you delete

Re: [sqlite] Q about new SQLite API

2006-11-07 Thread Peter Bierman
At 1:17 PM + 11/7/06, [EMAIL PROTECTED] wrote: QUESTION 1: sqlite3_prepare_v2 is the merely the working name for the new function. What should the official name be? I like sqlite3_prepare_v2. It lets me know that it's very similar to sqlite3_prepare, so lots of existing documentation

Re: [sqlite] v3.2.1 and current differences!

2006-06-26 Thread Peter Bierman
At 4:01 PM -0400 6/26/06, [EMAIL PROTECTED] wrote: Peter Bierman <[EMAIL PROTECTED]> wrote: At 2:20 PM -0400 6/26/06, [EMAIL PROTECTED] wrote: >SQLite 3.3.0 can read and write all prior versions of SQLite >databases. But SQLite 3.2.8 cannot read or write a database >created

Re: [sqlite] v3.2.1 and current differences!

2006-06-26 Thread Peter Bierman
At 2:20 PM -0400 6/26/06, [EMAIL PROTECTED] wrote: SQLite 3.3.0 can read and write all prior versions of SQLite databases. But SQLite 3.2.8 cannot read or write a database created by SQLite 3.3.0, unless you use PRAGMA legacy_file_format=TRUE; prior to creating the database, or unless you

Re: [sqlite] Feature Request: Open from fd

2006-01-04 Thread Peter Bierman
At 3:53 PM -0600 1/4/06, Aaron Laffin wrote: On 1/4/06, Peter Bierman <[EMAIL PROTECTED]> wrote: Related to a project I'm working on, it would be useful for me to be able to open a database file via passing an already open file descriptor to the sqlite open() call. sqlite3_

[sqlite] Feature Request: Open from fd

2006-01-04 Thread Peter Bierman
Related to a project I'm working on, it would be useful for me to be able to open a database file via passing an already open file descriptor to the sqlite open() call. sqlite3_openfd(). I need this because I'd prefer to resolve some filesystem permissions access issues in a separate process

Re: [sqlite] Proposed 3.3.0 changes. Was: 5/2==2

2005-11-01 Thread Peter Bierman
At 1:54 PM -0500 11/1/05, [EMAIL PROTECTED] wrote: Please let me restate the proposed change: I desire to change SQLite so that it no longer distinguishes between integer and real. The two concepts are merged into a unified "numeric" type. And because all number values are of the same type,

Re: [sqlite] How to determine if a column is autoincremented?

2005-10-24 Thread Peter Bierman
Actually, on SQLite, 'INTEGER PRIMARY KEY' does designate a special type of autoincremented column. The internal 64 bit rowid is used directly in that case, which is essentially 'free' storage. http://www.sqlite.org/faq.html#q1 http://www.sqlite.org/lang_createtable.html