[sqlite] PRAGMA foreign_key_list

The documentation for the above command on the SQLite web site is silent about the output of the above PRAGMA. I can guess at some of it but does anyone have a full description of it? Thanks, Pete lcSQL Software Home of lcStackBrowser

Re: [sqlite] Error: database is locked

On 06/18/2014 05:17 PM, JohnG wrote: gelmjw@voyager /var/www/sqlite3/finviz $ sqlite3 -version 3.7.9 2011-11-01 00:52:41 c7c6050ef060877ebe77b41d959e9df13f8c9b5e gelmjw@voyager /var/www/sqlite3/finviz $ gelmjw@voyager /var/www/sqlite3/finviz $ uname -a Linux voyager 3.2.0-23-generic #36-Ubuntu

Re: [sqlite] R-Tree Storage Optimization for Points

On 20/6/2014 8:08 PM, Clemens Ladisch wrote: Not without changing the SQLite code. A non-leaf R-tree node must store the extents covered by all its children, so these are (n-dimensional) rectangles. At the moment, SQLite assumes that user data has exactly the same format, so such a change

Re: [sqlite] another challenging query

you guys are flippin' gods ya know that right? thanks! On Jun 19, 2014, at 10:26 PM, Igor Tandetnik wrote: > On 6/20/2014 1:20 AM, David M. Cotter wrote: >> i want to delete from the table all records with plID = 1, but ONLY those >> that have a corresponding record where

[sqlite] another challenging query

here's a table: i want to delete from the table all records with plID = 1, but ONLY those that have a corresponding record where plID == 851090 and where that record's soID matches the one where plID = 1 so the query should delete rows 8-12, but leave 1-2 intact (and also leave 3-7) there

Re: [sqlite] R-Tree Storage Optimization for Points

Mohit Sindhwani wrote: > I was wondering if there is a way that we could save space on the > R-Tree storage if the item being inserting is just a single point > (such that x1=x2 and y1=y2). Not without changing the SQLite code. A non-leaf R-tree node must store the extents covered by all its

Re: [sqlite] R-Tree Storage Optimization for Points

Hello All... On 20/6/2014 3:01 AM, Wolfgang Enzinger wrote: I stand corrected. Should have tried this before: sqlite> INSERT INTO abc VALUES(2,30,20); Error: constraint failed Note to self: r-tree is about *ranges* in 1 to 5 dimensions. Coming back to the original problem again... I was

Re: [sqlite] another challenging query

On 2014/06/20 07:20, David M. Cotter wrote: i want to delete from the table all records with plID = 1, but ONLY those that have a corresponding record where plID == 851090 and where that record's soID matches the one where plID = 1 so the query should delete rows 8-12, but leave 1-2 intact