PostgreSQL 19 introduces GROUP BY ALL syntax, which automatically includes all non-aggregate and non-window function columns in the GROUP BY clause. This feature, recently accepted into the SQL standard, simplifies queries by eliminating the need to explicitly list grouping columns. Instead of writing 'GROUP BY col1, col2', developers can now use 'GROUP BY ALL' and PostgreSQL will automatically determine which columns to group by based on the SELECT list.
Sort: