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

2017-04-19 Thread Richard Hipp
On 4/19/17, Timothy Stack wrote: > > ​Richard, if I made the necessary changes to the parser, docs, and updated > the carray extension as an example, would you accept the patch? > Probably not. But an actual demonstration showing that your proposed enhancement is useful and does not impact perfo

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

2017-04-19 Thread Timothy Stack
On Sun, Apr 16, 2017 at 3:40 PM, Richard Hipp wrote: > > On 16 Apr 2017, at 10:57pm, Timothy Stack > > wrote: > > > >> UPDATE foo SET col0 = 'bar' WHERE hidden_field = 'baz' > >> > >> Having the real syntax, like the following, would be nice though: > >> > >> UPDATE foo('baz') SET col0 = 'bar'

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

2017-04-18 Thread Timothy Stack
ite-users-boun...@mailinglists.sqlite.org] > Im Auftrag von Timothy Stack > Gesendet: Sonntag, 16. April 2017 23:57 > An: SQLite mailing list > Betreff: [sqlite] performing an UPDATE on a table-valued function > > The current table-valued function feature seems to only work for SELECT &g

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

2017-04-18 Thread Hick Gunter
y executing a CREATE VIRTUAL TABLE statement. -Ursprüngliche Nachricht- Von: sqlite-users [mailto:sqlite-users-boun...@mailinglists.sqlite.org] Im Auftrag von Timothy Stack Gesendet: Sonntag, 16. April 2017 23:57 An: SQLite mailing list Betreff: [sqlite] performing an UPDATE on a table-

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

2017-04-16 Thread Timothy Stack
On Sun, Apr 16, 2017 at 3:40 PM, Richard Hipp wrote: > On 4/16/17, Simon Slavin wrote: > > > > On 16 Apr 2017, at 10:57pm, Timothy Stack > > wrote: > > > >> UPDATE foo SET col0 = 'bar' WHERE hidden_field = 'baz' > >> > >> Having the real syntax, like the following, would be nice though: > >> >

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

2017-04-16 Thread Richard Hipp
On 4/16/17, Simon Slavin wrote: > > On 16 Apr 2017, at 10:57pm, Timothy Stack > wrote: > >> UPDATE foo SET col0 = 'bar' WHERE hidden_field = 'baz' >> >> Having the real syntax, like the following, would be nice though: >> >> UPDATE foo('baz') SET col0 = 'bar' > > How would it know that 'baz' is

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

2017-04-16 Thread Simon Slavin
On 16 Apr 2017, at 10:57pm, Timothy Stack wrote: > UPDATE foo SET col0 = 'bar' WHERE hidden_field = 'baz' > > Having the real syntax, like the following, would be nice though: > > UPDATE foo('baz') SET col0 = 'bar' How would it know that 'baz' is a value for the column "hidden_field" rather

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

2017-04-16 Thread Timothy Stack
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