3 ms·
You might want to look at a unique partial index: "CREATE UNIQUE INDEX foo ON pages(name, parent_id) WHERE parent_id IS NOT NULL"
by radiospiel 4y ago
You might want to look at a unique partial index: "CREATE UNIQUE INDEX foo
ON pages(name, parent_id) WHERE parent_id IS NOT NULL"