[sqlite] user defined function returning a result set

2015-09-17 Thread Sylvain Pointeau
> > To do this, you'd have to create a virtual table that actually gets > instantiated per CSV file: > > CREATE VIRTUAL TABLE temp.file1 USING > csvFileReader('/path/to/my/file.csv'); > SELECT * FROM file1; > DROP TABLE file1; > > In the above, the xCreate method of the virtual

[sqlite] user defined function returning a result set

2015-09-14 Thread Sylvain Pointeau
Hello, I think I have read on this mailing list that sqlite now has functions able to return rows. (but cannot find it anymore) I am interested about this new functionality. Would it be possible to see a very basic sample of it? Do you think we can implement a kind of CSV reader with this new

[sqlite] user defined function returning a result set

2015-09-14 Thread Richard Hipp
On 9/14/15, Sylvain Pointeau wrote: > Hello, > > I think I have read on this mailing list that sqlite now has functions able > to return rows. (but cannot find it anymore) https://www.sqlite.org/draft/vtab.html#tabfunc2 > > I am interested about this new functionality. Would it be possible to