Re: [sqlite] How should I use parenthesis?

On Mon, 27 Jan 2014 18:57:26 +0100 Jean-Christophe Deschamps wrote: > ( > select * from A where x in (subselectA) > left outer join > select * from B where y in (subselectB) > ) > > union all > > ( -- <-- error > select * from B where y in (subselectC) > left outer join >

Re: [sqlite] How should I use parenthesis?

On 1/27/2014 12:57 PM, Jean-Christophe Deschamps wrote: I'm trying to find the correct syntaxt for this, but I hit a syntax error each time: either SQLite shokes on outer parenthesis or on union all. ( select * from A where x in (subselectA) left outer join select * from B where y in

[sqlite] How should I use parenthesis?

Dear list, I'm trying to find the correct syntaxt for this, but I hit a syntax error each time: either SQLite shokes on outer parenthesis or on union all. ( select * from A where x in (subselectA) left outer join select * from B where y in (subselectB) ) union all ( -- <-- error select *

Re: [sqlite] pragmas in subselects?

On Sun, Jan 26, 2014 at 9:45 PM, Jay Kreibich wrote: > > Chapter 10 of Using SQLite covers virtual tables. One of the examples > given shows how to wrap a PRAGMA statement, so it can be used as system > catalog and used in normal SELECT statements. It would be pretty easy to >

Re: [sqlite] Tcl variable substitution issue

I apologize for not replying directly to your messages. My account on this mailing list is not set up to send me individual messages. Richard Hipp wrote: You should do what you want, of course. But this statement is surprising since SQLite is really just a TCL extension that has "escaped" into

Re: [sqlite] pragmas in subselects?

big stone wrote: > There is a non-logicality of having "pragma table_info(my_table)" : > - answering like a select, > - but being not usable as a "select", nor queriable by a "select". SQLite's PRAGMA implementations do not plug into the internal query mechanism used by SELECT, but hardcode a