Re: why databses don't support 'boolean' type?

From: David Portas <REMOVE_BEFORE_REPLYING_dportas_at_acm.org>
Date: 14 Oct 2006 01:57:50 -0700
Message-ID: <1160816270.299334.138740@i42g2000cwa.googlegroups.com>

fireball wrote:

> is there any reason not to supprt 'boolean' type in database(s)? just
> curious..

The ANSI/ISO SQL Standard has included a BOOLEAN datatype since 1999 but it isn't widely supported. The SQL version is a fudge because of the conundrums inherent in 3-valued logic. The perceived defects of their approach maybe explain why it hasn't been implemented by the major vendors.

-- 
David Portas

Received on Sat Oct 14 2006 - 03:57:50 CDT