Could someone please clarify the difference between "RETURNS NULL ON
NULL INPUT" or "STRICT" when creating a function. Do both options exist
because of historical reasons/SQL standard compliance?
Shouldn't we raise an error when calling a function with NULL arguments
values if the function is created as STRICT?
(This would of course have an impact on checking for NULLs on arguments
defaults if the above is implemented.)
--
Regards,
Gevik