5 PostgreSQL Features To Improve Your SQL
This title could be clearer and more informative.Try out Clickbait Shieldfor free (5 uses left this month).
A walkthrough of five built-in PostgreSQL features that simplify common SQL tasks: the FILTER clause for cleaner aggregate conditions, DISTINCT ON for retrieving one row per group, the RETURNING keyword to get data back from INSERT/UPDATE/DELETE in a single query, specialized data types (UUID, inet, money), and transactional DDL that allows schema changes to be rolled back safely.
•5m watch time