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

Reply via email to