Re: [sqlite] Consider adding aggregate function "string_agg" as synonym of "group_concat"

2018-09-01 Thread Zsbán Ambrus
On Sun, Sep 2, 2018 at 12:29 AM Simon Slavin wrote: > On 1 Sep 2018, at 11:03pm, Zsbán Ambrus wrote: > > Would you consider adding an aggregate function "string_agg" which is > > a synonym for the "group_concat" function but takes only two > > arguments? > > Could you look up the definition of

[sqlite] Missing External Declarations

2018-09-01 Thread Keith Medcalf
1. sqlite3_create_window_function(...) is not available in the indirection list (sqlite3ext.h) and so you cannot have an "Windowing Function" in a loadable extension, they must all the part of the core (appended to the amalgamation file). 2. the fileio.c extension also only works (will only

Re: [sqlite] Consider adding aggregate function "string_agg" as synonym of "group_concat"

2018-09-01 Thread Simon Slavin
On 1 Sep 2018, at 11:03pm, Zsbán Ambrus wrote: > Would you consider adding an aggregate function "string_agg" which is > a synonym for the "group_concat" function but takes only two > arguments? Could you look up the definition of the existing function on

[sqlite] Consider adding aggregate function "string_agg" as synonym of "group_concat"

2018-09-01 Thread Zsbán Ambrus
Dear SQLite developers, Would you consider adding an aggregate function "string_agg" which is a synonym for the "group_concat" function but takes only two arguments? This would let me use the function the same in SQLite and MS SQL Server and PostgreSQL. The relevant documentation for the