yeah there is some logic to that. Certainly easier to implement ;)<br><br>I guess thinking of business rules - nulls are evil things. Even in a database, they are evil. Many an important report is incorrect cause it is built on a database that allows null values, and people don't understand the ramifications of the SQL statements used.
<br><br>Nulls in your fact model: just say no !<br><br>of course... back in the real world...<br><br>Some other thoughts:<br><br>Foo(bar < 3) makes no sense if bar is null, so it should be false always in my opinion.<br>
<br>However, Foo(bar != 3) is not so clear for null behaviour.<br><br><div><span class="gmail_quote">On 3/15/07, <b class="gmail_sendername">Steven Williams</b> <<a href="mailto:stevearoonie@gmail.com">stevearoonie@gmail.com
</a>> wrote:</span><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">I agree with SQL. If you also want to catch null you could do<br><br>Foo(field > 3 | == null)
<br><br>cheers<br>Steve<br><br><div><div><span class="e" id="q_11154343cd392da2_1"><span class="gmail_quote">On 3/15/07, <b class="gmail_sendername">Michael Neale</b> <<a href="mailto:michael.neale@gmail.com" target="_blank" onclick="return top.js.OpenExtLink(window,event,this)">
michael.neale@gmail.com</a>> wrote:</span></span></div><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;"><div><span class="e" id="q_11154343cd392da2_3">
<a href="http://jira.jboss.com/jira/browse/JBRULES-627" target="_blank" onclick="return top.js.OpenExtLink(window,event,this)">
http://jira.jboss.com/jira/browse/JBRULES-627</a><br><br>OK, this much is clear: <br><br>Foo(field == null) can be true if field is null.<br><br>but, what about Foo(field > 3), and field is null? should that be false? what about Foo(field != 3) - should that be true?
<br><br>in SQL, null will always result in a false condition, unless you explicitly use null.<br><br>Thoughts? <br><span><br>Michael.<br>
</span><br></span></div>_______________________________________________<br>rules-dev mailing list<br><a href="mailto:rules-dev@lists.jboss.org" target="_blank" onclick="return top.js.OpenExtLink(window,event,this)">rules-dev@lists.jboss.org
</a><br><a href="https://lists.jboss.org/mailman/listinfo/rules-dev" target="_blank" onclick="return top.js.OpenExtLink(window,event,this)">
https://lists.jboss.org/mailman/listinfo/rules-dev</a><br><br></blockquote></div><br><br clear="all"><br>-- <br>Steven Williams<br><br>Supervising Consultant<br><br>Object Consulting<br>Office: 8615 4500 Mob: 0439 898 668 Fax: 8615 4501
<br><a href="mailto:stevenw@objectconsulting.com.au" target="_blank" onclick="return top.js.OpenExtLink(window,event,this)">stevenw@objectconsulting.com.au</a><br><a href="http://www.objectconsulting.com.au" target="_blank" onclick="return top.js.OpenExtLink(window,event,this)">
www.objectconsulting.com.au</a><br><br>consulting | development | training | support
<br>our experience makes the difference
<br>_______________________________________________<br>rules-dev mailing list<br><a onclick="return top.js.OpenExtLink(window,event,this)" href="mailto:rules-dev@lists.jboss.org">rules-dev@lists.jboss.org</a><br><a onclick="return top.js.OpenExtLink(window,event,this)" href="https://lists.jboss.org/mailman/listinfo/rules-dev" target="_blank">
https://lists.jboss.org/mailman/listinfo/rules-dev</a><br><br></blockquote></div><br>