Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> comp.databases.theory -> Re: The BOOLEAN data type

Re: The BOOLEAN data type

From: --CELKO-- <71062.1056_at_compuserve.com>
Date: 17 Apr 2003 15:26:02 -0700
Message-ID: <c0d87ec0.0304171426.29003dcb@posting.google.com>


>> An empty set is different from NULL. <<

An empty scalar query converts to a NULL in Standard SQL, so you have to watch the usage.

Another problem with BOOLEAN datatypes is that they apply to propositions; A table is a collection of facts, if you believe Chris Date. Opps, we are now working at two different levels an get allthose self-referencing problems. Received on Thu Apr 17 2003 - 17:26:02 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US