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 program
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
On Sun, Jan 26, 2014 at 9:45 PM, Jay Kreibich j...@kreibi.ch 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
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 *
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
On Mon, 27 Jan 2014 18:57:26 +0100
Jean-Christophe Deschamps j...@antichoc.net 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