Обсуждение: CHECK constraint so that only one is TRUE?

How would you write a check constraint to ensure that only one column,
of type boolean, is set to TRUE for a given ID?

Thanks.