<p class="MsoNormal">Could someone please clarify the difference between <tt><span lang="EN" style="font-size: 10pt;
line-height:115%; color: black;">"RETURNS NULL ON NULL INPUT</span></tt><span lang="EN" style="font-size: 9pt;
line-height:115%; font-family: "Verdana","sans-serif"; color: black;">" or "</span><tt><span lang="EN"
style="font-size:10pt; line-height: 115%; color: black;">STRICT" when creating a function. Do both options exist
becauseof historical reasons/SQL standard compliance?<br /></span></tt><p class="MsoNormal"><tt><span lang="EN"
style="font-size:10pt; line-height: 115%; color: black;"><br /> Shouldn't we raise an error when calling a function
withNULL arguments values if the function is created as STRICT?<br /> (This would of course have an impact on checking
forNULLs on arguments defaults if the above is implemented.)</span></tt><br /><p class="MsoNormal">-- <br /><pre
class="moz-signature"cols="72">Regards,
Gevik</pre>
