RE: Consistent Null Handling

From: Lex de Haan <lex.de.haan_at_naturaljoin.nl>
Date: Fri, 3 Sep 2004 11:12:41 +0200
Message-ID: <JFEEIGBIDOCCDALDIPLNGEAECIAA.lex.de.haan@naturaljoin.nl>

Ian,
it better be true for all those implementations -- because this is what the ANSI/ISO standard is telling us to do ;-) please, invite me to teach my favorite one-day seminar on this topic ...  

Kind regards,
Lex.  

---

visit http://www.naturaljoin.nl

---

skype me <callto://lexdehaan>

-----Original Message-----
From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org]On Behalf Of MacGregor, Ian A. Sent: Thursday, September 02, 2004 19:43 To: oracle-l_at_freelists.org
Subject: Consistent Null Handling

One of the posts on "Cure for Madness" brought up consistent null = handling which Oracle does not do. For instance, "Select Column1 + Column2 from TableA;" returns null if either or both = columns are null. However "Select sum(Column1) from table A" will = return a value if there are non-null values in the column. Is this true = for all SQL versions? =20

Ian MacGregor
Stanford Linear Accelerato Center
ian_at_SLAC.Sranford.edu

---
To unsubscribe - mailto:oracle-l-request_at_freelists.org&subject=unsubscribe 
To read recent messages - http://freelists.org/archives/oracle-l/09-2004




-- Binary/unsupported file stripped by Ecartis --

-- Type: text/x-vcard

-- File: Lex de Haan.vcf



---
To unsubscribe - mailto:oracle-l-request_at_freelists.org&subject=unsubscribe 
To read recent messages - http://freelists.org/archives/oracle-l/09-2004

Received on Fri Sep 03 2004 - 04:08:26 CDT