Waiting for PostgreSQL 19 – Add GROUP BY ALL.

Read Original

The article details the new GROUP BY ALL feature committed for PostgreSQL 19. It explains how this syntax automatically adds any target expression without an aggregate or window function to the GROUP BY clause, aligning with the SQL standard and simplifying query writing for data exploration, with examples provided.

Waiting for PostgreSQL 19 – Add GROUP BY ALL.

Comments

No comments yet

Be the first to share your thoughts!

Browser Extension

Get instant access to AllDevBlogs from your browser

Top of the Week