PostgreSQL

---

Table of contents

• Aggregate functions over partition in PostgreSQL
• Dates overlapping with PostgreSQL
• Finding most recent children for a record in PostgreSQL
• Group by JSONB array in PostgreSQL
• Limit with ties in PostgreSQL
• Moving data from database column to jsonb field
• Natural join in SQL
• Pivot functions in PostgreSQL
• Recursive SQL queries with PostgreSQL
• ROLLUP and CUBE with PostgreSQL
• Running multiple PostgreSQL versions on MacOS
• Text search with PostgreSQL
• Update primary key with foreign constraints
• Upsert in PostgreSQL