I didn't know about: CREATE TABLE foo(mycolumn BOOLEAN NOT NULL CHECK (mycolumn IN (0,1)));

but we agree, "But of course, a real Boolean column type would be better".