Re: [sqlite] performing an UPDATE on a table-valued function

On Sun, Apr 16, 2017 at 3:40 PM, Richard Hipp <d...@sqlite.org> wrote: > > On 16 Apr 2017, at 10:57pm, Timothy Stack <timothyshanest...@gmail.com> > > wrote: > > > >> UPDATE foo SET col0 = 'bar' WHERE hidden_field = 'baz' > >> > >> Having

Re: [sqlite] performing an UPDATE on a table-valued function

ite-users-boun...@mailinglists.sqlite.org] > Im Auftrag von Timothy Stack > Gesendet: Sonntag, 16. April 2017 23:57 > An: SQLite mailing list <sqlite-users@mailinglists.sqlite.org> > Betreff: [sqlite] performing an UPDATE on a table-valued function > > The current table-valued

Re: [sqlite] performing an UPDATE on a table-valued function

On Sun, Apr 16, 2017 at 3:40 PM, Richard Hipp <d...@sqlite.org> wrote: > On 4/16/17, Simon Slavin <slav...@bigfraud.org> wrote: > > > > On 16 Apr 2017, at 10:57pm, Timothy Stack <timothyshanest...@gmail.com> > > wrote: > > > >>

[sqlite] performing an UPDATE on a table-valued function

The current table-valued function feature seems to only work for SELECT statements. Was any thought given to whether updates would be supported for table-valued functions? It seems like it's technically possible and could be made to work right now with this awkward syntax: UPDATE foo SET col0

Re: [sqlite] sqlite with Java

I see that you've got a solution working, but I wanted to mention this project which is a JDBC driver that can work with a dynamically linked sqlite library so there shouldn't be anything to recompile: https://github.com/tstack/SqliteJdbcNG Unfortunately, it hasn't seen updates for a couple

[sqlite] will aggregate functions be added to the json extension ?

Hello, Are there any plans to add aggregate functions to the json extension so that json arrays can be produced from a result set? I found a message on the json feedback thread from a few months ago that brought this up, but there didn't seem to be a response: