SQL SEQUENCE in PostgreSQL: one ID generator for multiple tables
Solving the shared document numbering problem
Need shared numbering for invoices and delivery notes, but SERIAL creates duplicates across different tables? SEQUENCE solves this elegantly. We will explore real scenarios, gotchas (number gaps!), and explain why in 90% of cases simple SERIAL is all you need ✨
