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 function in the latter two are "https://docs.microsoft.com/en-us/sql/t-sql/functions/string-agg-transact-sql?view=sql-server-2017"; and "https://www.postgresql.org/docs/9.0/static/functions-aggregate.html"; . Neither MS SQL nor PostgreSQL have a "group_concat" function. This would be very easy to implement from the SQL core, which already implements group_concat, and more difficult to implement as a user extension that only uses the SQLite API. SQLite already has a precedent for having a synonym for a function provided by the core: "ifnull" is a synonym for "coalesce" with two arguments. -- Zsbán Ambrus _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
