Re: The BOOLEAN data type

>> Let's say you have a table of product orders and you need to know
which one's have been shipped and which one's haven't. That's a boolean value that can't be computed from other data. <<

Wrong:

 CREATE TABLE Orders
 (order_nbr INTEGER NOT NULL PRIMARY KEY,   ..
  ship_date DATE, -- null means not yet shipped   ..);

And please don't tell that you would not record the shipping date, shipping charges, shipping method, etc. in the database. Received on Tue Apr 08 2003 - 18:11:22 CDT