Agree its a bit unnatural, but it seems workable. My problem with the auxiliary ... | Hacker News

Hacker Newsnew | past | comments | ask | show | jobs | submit

		evv on July 11, 2022 \| parent \| context \| favorite \| on: Postgres 15 improves UNIQUE and NULL Agree its a bit unnatural, but it seems workable. My problem with the auxiliary table is, I wouldn't know how to implement the unique constraint.

SnowHill9902 on July 11, 2022 [–]

In your current implementation you either have no unique constraint or it is a more particular case of UNIQUE(ancestor, descendant).

Guidelines | FAQ | Lists | API | Security | Legal | Apply to YC | Contact