Re: The BOOLEAN data type
From: --CELKO-- <71062.1056_at_compuserve.com>
Date: 8 Apr 2003 16:11:22 -0700
Message-ID: <c0d87ec0.0304081511.36fdbd40_at_posting.google.com>
Date: 8 Apr 2003 16:11:22 -0700
Message-ID: <c0d87ec0.0304081511.36fdbd40_at_posting.google.com>
>> 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 Wed Apr 09 2003 - 01:11:22 CEST