By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
| version |
|---|
| PostgreSQL 11.7 on x86_64-pc-linux-gnu, compiled by gcc (GCC) 8.3.1 20190507 (Red Hat 8.3.1-4), 64-bit |
4 rows affected
8 rows affected
| id | category | parent_id | note |
|---|---|---|---|
| 1 | order | nil | order with no invoices |
| 2 | order | nil | order with invoices |
| 3 | invoice | 2 | invoice for order 2 |
| 4 | invoice | 2 | invoice for order 2 |