Re: [sqlite] Virtual Table "Functions"

* from XMLPARSE(' select * from FILE("data.xml") ') but without the thorny quote escaping problems. The "select * from " part is optional (it is autocompleted) so above query could be rewritten to: XMLPARSE FILE "data.xml"; Both XMLPARSE and FILE are r

Re: [sqlite] Virtual Table "Functions"

On Fri, Feb 28, 2014 at 10:14 PM, Dominique Devienne wrote: > Can someone tell me how the statement below works? > > > Thanks for any help on this. This is really puzzling to me. --DD Very puzzling for me too For any statement like this select * from blablabla(123) sqlite (3.8.3.1) prim

[sqlite] Virtual Table "Functions"

Can someone tell me how the statement below works? > From Eleytherios Stamatogiannakis : > create table newtable as select * from READCOMPRESSEDFILE('ctable.rc'); I'm using virtual tables extensively in my application, to expose runtime C++ objects, and I'm declaring them as shown in http://www.s