Subject | boolean domain and IBO |
---|---|
Author | Aleš Kahánek |
Post date | 2002-05-21T12:59Z |
Hi All,
what definition of boolean domain do you recommend when using IBO? Which one
is "better"?
1. CREATE DOMAIN D_BOOLEAN AS CHAR(1) CHECK (VALUE IN ("T","F")) NOT NULL;
2. CREATE DOMAIN D_BOOLEAN AS SMALLINT DEFAULT 0
CHECK (VALUE BETWEEN 0 AND 1);
Thanks Ales
what definition of boolean domain do you recommend when using IBO? Which one
is "better"?
1. CREATE DOMAIN D_BOOLEAN AS CHAR(1) CHECK (VALUE IN ("T","F")) NOT NULL;
2. CREATE DOMAIN D_BOOLEAN AS SMALLINT DEFAULT 0
CHECK (VALUE BETWEEN 0 AND 1);
Thanks Ales