By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
| version |
|---|
| PostgreSQL 17.2 (Debian 17.2-1.pgdg120+1) on x86_64-pc-linux-gnu, compiled by gcc (Debian 12.2.0-14) 12.2.0, 64-bit |
SELECT 1
CREATE TABLE
INSERT 0 4
CREATE TABLE
INSERT 0 3
CREATE TABLE
INSERT 0 3
| pk | pk | fk |
|---|---|---|
| one | 6 | one |
| one | 7 | one |
| six | null | null |
| ten | 8 | ten |
| two | null | null |
SELECT 5
| pk | fk | pk | fk |
|---|---|---|---|
| 6 | one | null | null |
| 7 | one | curly | 7 |
| 7 | one | larry | 7 |
| 8 | ten | moe | 8 |
SELECT 4
| pk | pk | fk | pk | fk |
|---|---|---|---|---|
| one | 6 | one | null | null |
| one | 7 | one | curly | 7 |
| one | 7 | one | larry | 7 |
| six | null | null | null | null |
| ten | 8 | ten | moe | 8 |
| two | null | null | null | null |
SELECT 6