Subject RE: [Firebird-general] See, this is why we need a native BOOLEAN type
Author Si Carter
> -----Original Message-----
> http://thedailywtf.com/forums/57164/ShowPost.aspx

LOL, never seen that website before.

Now I have to make a decision on which of the following domains to use for
all new databases:

CREATE DOMAIN DOMAIN_BOOL AS VARCHAR(9)
DEFAULT 'Firebird' NOT NULL
CHECK (VALUE IN ('Interbase', 'Firebird'));

CREATE DOMAIN DOMAIN_BOOL AS VARCHAR(6)
DEFAULT 'Picard' NOT NULL
CHECK (VALUE IN ('Kirk', 'Picard'));

CREATE DOMAIN DOMAIN_BOOL AS VARCHAR(5)
DEFAULT 'Vodka' NOT NULL
CHECK (VALUE IN ('Vodka', 'Lager'));

Rgds

Si Carter
http://www.fbtalk.net/ - Web Based Firebird Forum
http://sourceforge.net/projects/fbutils - FBUtils
http://www.tectsoft.net/ - Homepage