Monthly Shaarli
October, 2018
constraints - SQL: how to enforce that only a single column is set in a group of columns - Stack Overflow

Code for Postgres:
ALTER TABLE users ADD CONSTRAINT enforce_single_not_null_column CHECK(
(CAST(parent_id IS NOT NULL AS int) +
CAST(teacher_id IS NOT NULL AS int)) <= 1)