> How shall I create a constraint such that only one row may be 'true'?
Instead of, or along with your pg boolean, use a C type boolean where
true is 1 and false is null: ... col_tf int check( col_tf = 1 || col_tf is null ) unique, ...
a kludge to be sure, but works
__________________________________
Do you Yahoo!?
The New Yahoo! Search - Faster. Easier. Bingo.
http://search.yahoo.com