Home > mailing lists

CHECK constraint so that only one is TRUE? - Mailing list pgsql-general

From	incognit@unifiedmind.com (+I)
Subject	CHECK constraint so that only one is TRUE?
Date	January 18, 2002 16:50:44
Msg-id	ebcd475a.0201121104.62d46853@posting.google.com Whole thread Raw
List	pgsql-general

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.

From: ph02116@yahoo.com (ph01803)
Date: 18 January 2002, 16:50:36
Subject: Having problem with initdb on my Solaris 8 box

From: Justin Clift
Date: 18 January 2002, 16:51:21
Subject: Re: Kindly help.