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
> select * from A where
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 (subselectB
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 * fr
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
> expand the given
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 t
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 VDBE
6 matches
Mail list logo