4 ms·
> As you probably know, the group_concat function is SQLite (and MySQL) specific. In other databases (namely, PostgreSQL and SQL Server) the function is called
by bambax 3y ago
> As you probably know, the group_concat function is SQLite (and MySQL) specific. In other databases (namely, PostgreSQL and SQL Server) the function is called string_agg. As of 3.44, SQLite also supports string_agg as an alias for group_concat(expr, sep) (...) Now the only black sheep is Oracle, where the poor function is called listagg.
Minor nitpick, but why not go all the way and add the Oracle syntax while they were at it? Is there a technical reason not to? (I've never used Oracle)
- ranting-moth 3y agoI don't know why exacly, but there's a good general reason not to touch anything made by Oracle: lawsuits.
- giraffe_lady 3y agoI don't think they're doing it to match a DB vendor consensus I suspect they're doing it because postgres specifically does. I'm not aware of any official expression of this, but for the past several years at least sqlite seems to be treating what postgres does as a sort of spec, and aligning with its behavior unless they have a specific reason not to. Which is great imo.
- bambax 3y agoAh yes that would explain it, thanks.